Compatibility upgrade SQL server + SSDT 2012 to 2019 version

Question

hi Micrososft team.

we want to upgrade SQL server from 2012 to 2019, and we have SSDT 2012 also want to upgrade it to SSDT 2019.
we using common fuction on SSDT ( OLEDB connection between DB / table , standart tools on SSDT, export to flatfile and set scheduler for ETL ).
currently for OS we using windows server 2012.

my question are :

1. is there any concern about compatibilty between this 2 version of SQL Server and SSDT (2012-2019) ?
2. for SSDT is possible just to import package from 2012 into 2019 or we need to reconfigure something on 2019 to run package 2012 version ?

Answer 1

Hi @Mikha Mangudu ，

First, you should know, SQL Server 2019 is not supported on Windows server 2012
From this article:

Putting aside the OS, before upgrade SQL Server, suggest you using DMV tool for compatibility issues and new feature's recommendation.

SSDT supports backwars compatibility up to SQL Server 2012, you can always use the newest SSDT to design and deploy database and so on that run on older versions of SQL Server

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.