Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 updating new datamodel changes to existing sql db

Author  Topic 

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2011-04-20 : 04:56:03
Hi,


we are trying upgrade our db application to newer version.

right now we have 1.1 version (sql server 2005) and new version is 1.2 (sql 2008)

there are few new tables and columns in new version.

So when we migrate new data model chages to existing version database, just wondering what needs to be take care and how to start , who will do this task a dba or developer?

Kind of new to this task, any ideas would be appreciated. thank you.

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-04-20 : 05:35:42
Yep this all Upgrade part is handled by DBA only.
If DBA trying to update directly on Production server then don't upgrade this version.
First you need to try on test server if this works on test server then try on Production server.
There are many things to take care before updating on production server like
1 Taking all database backup (system and user)
2 Upgrade SQL 2005 to latest service pack
3 Once latest service pack is installed on 2005 then you need to upgrade this with SQL 2008
4 This all try first on test server if this go fine
Then try on Production server
5 On production server you need to do this at week end
6 If anything go wrong then you can restore this back by your database backup which is taken in 1 st step

Raghu' S
Go to Top of Page

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2011-04-20 : 07:48:21
hi raghu,

Thanks for your reply.
lets say i upgraded the sql first.

Is there any third party tool to deploy the new data model changes in existing sql db

Go to Top of Page

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-04-20 : 09:13:53
First test the scripts on Test Database,if you have several scripts then create a bat and execute this batch SQLCMD in a 1 go

Then all scripts tested then raghuveer125 steps are well enough but if you fail in the upgradation process then install a fresh named instance of SQL Server 2008 R2 then take a backup of database and then restore on the newly named instance of sql server 2008 R2


Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com
Go to Top of Page
   

- Advertisement -