question

mohanraj6 avatar image
mohanraj6 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.
sql-server-2008-r2
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Do you mean you are upgrading your database from 2008R2 and want to know the differences between going to 2012 or 2014?
0 Likes 0 ·

1 Answer

· Write an Answer
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
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/
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks Magnus ahlkvist.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.