migration

Question

HI ALL,

please send me migration documentation

 need to migrate sql server 2005 to sql server 2012, so create a checklist so it can be seamless migration.Need to create the scripts as well which can be used while building up servers from old to new

Thanks everyone

Answer 1

Hi,

You may refer following article.

Migrating to SQL Server 2012

In General guide for upgrading the database.

1. Run upgrade advisor on the databases for the instance you want to upgrade.
2. If any issues found, talk to your dev team/ Vendor for fixing the same.
3. If issues fixed proceed with the actual upgrade. -- Do check for the other dependencies on the database which might effect the functionality if the instance gets upgraded or something like that.
4. Get the downtime for the database.
5. create a latest full backup of the database -- any other strategy will also work, just make sure you can recover the database.
6. take a clone of the server if its a virtual server to roll back any changes.
7. run the upgrade on the sql 2005 instance from the 2012 set up. -- do check the pre-requirements for upgrade to sql 2012.
8. If everything fine then you have a upgraded instance.
9. also check the compatibility of the databases.

---

Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
Praveen Dsa | MCITP - Database Administrator 2008 | My Blog | My Page

Answer 2

In adition to Praveen's post, you can refer the below links

http://thomaslarock.com/2013/03/upgrading-to-sql-2012-ten-things-you-dont-want-to-miss/

The below link is for 2000 to 2008 Migration but there are many useful points included in the article.

http://blogs.msdn.com/b/cindygross/archive/2009/10/28/checklist-for-upgrading-to-a-new-version-of-sql-server.aspx

--Prashanth

Answer 3

Hello,

Please refer to the SQL Server 2012 Upgrade Technical Guide. Download it from the following URL.

http://download.microsoft.com/download/9/5/3/9533501A-6F3E-4D03-A6A3-359AF6A79877/SQL_Server_2012_Upgrade_Technical_Reference_Guide_White_Paper.pdf

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com