June 24, 2012 at 11:30 pm
IS it possible to move 2000,2005 database straightly to 2012, because i have planned to migrate from 2000 and some 2005 databases to 2012...
If we can what are the steps would be precautions,
Please share with your valuable comments on here.....
June 24, 2012 at 11:48 pm
Hi
Yes you can directly migrate SQL 2000 and 2005 databases without any hassles, you need to change the compaitbily level once you restore.
It is almost similar to migrating to 2008, However run the Upgrade advisor to see if you get any compability issues.
Please let us know if you are upgrading the SQL boxes to 2012 along with the Databases or Moving the databases to a SQL Server where you have 2012 already installed.
Regards
Srikanth Reddy
June 25, 2012 at 12:18 am
What will happen, if 2000 sp's query's likes *= or =* ,
June 25, 2012 at 12:36 am
June 25, 2012 at 2:23 am
Old style joins will not function in 2012 as already said there is no level 80 any more in 2012.
To upgrade 2000 to 2012, first upgrade to 2005, sort out your joins, then upgrade to 2012.
June 25, 2012 at 5:09 am
Prior to upgrading any of these databases, run the free tool from Microsoft, the SQL Server 2012 Upgrade Advisor. It will validate if you have any T-SQL coding issues or structural problems that could present issues during the upgrade. Address these, then upgrade.
And yes, just to reinforce, you cannot go from 2000 to 2012. You must go through either 2005, 2008, or 2008R2 first.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 25, 2012 at 5:33 am
Thanks for all valuable feedback... I think first 2000 to 2005 and clearing all the issues then will move to 2012,? but it will take lot of time for single customer..also
June 25, 2012 at 5:39 am
Saravanan_tvr (6/25/2012)
Thanks for all valuable feedback... I think first 2000 to 2005 and clearing all the issues then will move to 2012,? but it will take lot of time for single customer..also
Make sure you run the upgrade advisor for 2005 too. You could face issues getting there from 2000.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 25, 2012 at 5:45 am
Yes I can..thanks
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply