May 27, 2014 at 3:10 pm
Hello Everyone,
I am new here. I was recently handed a project to create an environment with Windows 2012 and SQL 2012. The goal is to take the existing databases in our current environment which is SQL 2005 and Windows 2003 platform. I have tried looking for specific whitepapers to doing this or checklists that might exist. What are some of the things I should plan for, can I de-attach a database in the SQL 2005 environment. I did check the compatibility version for SQL 2005 environment is 90. Any help would be appreciated. I feel as if I might be in over my head.
Also, since I am moving to the new platform, do I need to do this in a cumulative process, where 2005 is upgraded to SQL 2008 R2 and than upgrade to 2012 R2.
Regards,
Sahluwalia
May 28, 2014 at 7:13 am
First of all take it very slow.... and plan, plan, plan...
A test environment is needed to test our your upgrade process and test out running process against the new environment.
Download the SQL Server Upgrade Advisor, run this against your production databases to make sure there aren't any issues within the dbs that will cause major problems.
There are several ways to upgrade to new hardware. The way I do it is use SP_HELP_REVLOGIN, run this on your SQL2005 system, then on the SQL2012 system create empty databases named the same as in SQL2005, then run the output from the REVLOGIN to recreate the logins. Then, backup/restore the databases onto the SQL2012 system and after that, at minimum run a 100% Update stats. It is best to rebuild all indexes if the databases aren't too large. For SSIS packages you will have to recreate those if you have any. Jobs in SQLAGENT you will have to script out and recreate.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply