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.
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 like1 Taking all database backup (system and user)2 Upgrade SQL 2005 to latest service pack3 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 server5 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 stepRaghu' S |
 |
|
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 |
 |
|
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 goThen 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 R2Regards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBAMy Blogwww.aureus-salah.com |
 |
|
|
|
|
|
|