asked
Pros and cons for migrating data from sql 2008R2 to sql 2012 vs 2014
What are the pros and cons for migrating data from SQL Server 2008R2 to SQL server 2012 vs 2014 ? Pre-requisites and steps for achieving the same.
Do you mean you are upgrading your database from 2008R2 and want to know the differences between going to 2012 or 2014?
I would go directly to SQL Server 2014. An upgrade from SQL Server 2008R2 is possible directly to SQL Server 2014, and SQL Server 2014 will maintain supported longer than SQL Server 2012. For a future upgrade, you are probably better off on a later version of SQL Server. Run upgrade advisor on your database and on any scripts stored outside of the server instance prior to upgrading. You should also decide if you can handle an in place upgrade, or if you want to install SQL Server 2014 as a separate instance and migrate your databases to that instance before getting rid of the SQL Server 2008R2 instance. For more information on upgrading to SQL Server 2014 - see MSDN:
http://msdn.microsoft.com/en-us/library/bb677622.aspx I would also recommend looking through (and following) this 12 step list of upgrade tasks:
http://thomaslarock.com/2014/06/upgrading-to-sql-server-2014-a-dozen-things-to-check/
15 People are following this question.
