Best Migration Path from MS SQL Server 2005 to MS SQL Server 2012
Posted on 2014-10-07
Can somebody provide the best plan, path, tools/utilities, and processes to use in order to migrate an existing MS SQL Server 2005 instance running on Windows Server 2003 to MS SQL Server 2012 running on Windows Server 2012 ? For example, are there built-in migration wizards that work well, and if so does one first have to migrate from MS SQL Server 2005 to MS SQL Server 2008 (and then from MS SQL Server 2008 to MS SQL Server 2012) to use those migration wizards ? Or can one effectively use migration wizards built-in to a new installation of MS SQL Server 2012 to migrate from the existing MS SQL Server 2005 server ? Do the built-in MS SQL wizards work pretty well, or are there some relatively inexpensive but effective third party tools (from Idera or others perhaps) that are well worth the money for such a project ? And finally, are the DBs and Stored Procedures the main things that need to be migrated ? Or are there any other processes or rules or alerts that need to be researched or migrated as well ? TIA ...