3

We plan to upgrade SQL 2008R2 to SQL 2016. We want to upgrade database servers first. We have separate SQL 2008R2 servers for SSIS and SSRS. SSIS packages are stored as files.

My question is:

After upgrading all database servers to SQL 2016, will all the SQL 2008R2 SSIS and SSRS servers work with the SQL 2016 databases?

Appreciate your experience.

5

At our location, we have SSIS running on SQL Server 2012. Our databases are on SQL Server 2016. We haven't had any issues with any of them, but then again, it really depends on what your packages are doing.

My recommendation is to have some sort of "sandbox" server and restore one of the databases and change the compatibility level to the latest level. Then test the SSIS packages to see if they would work.

  • Thanks! This certainly will encourage our dev teams to upgrade their databases to SQL 2016. – James Oct 13 '17 at 20:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.