What are the impact of existing application and steps need to be followed while upgrading SQL server 2012 to 2016

Question

User-1024101449 posted

My company informed to development team to upgrade of SQL server from 2012 to 2016.

What are the impact of existing application and steps need to be followed while upgrading SQL server 2012 to 2016. ?

What are the main points needs to be noted for the applications (web and Windows).?

Answer 1

User753101303 posted

Hi,

You could try: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/prepare-for-upgrade-by-running-data-migration-assistant?view=sql-server-ver15

Also looks around https://docs.microsoft.com/en-us/sql/database-engine/discontinued-database-engine-functionality-in-sql-server?view=sql-server-ver15 (and for SQL Server 2014) which include:
- breaking changes
- deprecated features (still work but may  not later)
- you'll find also a "what's new" section for new things you can now use

Answer 2

User1535942433 posted

Hi gani7787,

Accroding to your description,as far as I think,you need to compare Database Schemas.

More details,you could refer to below articles:

Compare and Synchronize Database Schemas:

https://docs.microsoft.com/en-us/previous-versions/visualstudio/visual-studio-2010/dd193250(v=vs.100)?redirectedfrom=MSDN

Select new database:

https://samanthaneilen.github.io/2017/11/24/managing-a-sql-server-database-from-a-visual-studio-database-project.html

Best regards,

Yijing Sun