Can development in Visual Studio 2019 run on SQL server 2016

• craig.bobchin

  SSCrazy

  Points: 2298

  More actions

  March 28, 2022 at 10:34 pm

  #4007345

  HI all,

   

  Our production system is a SQL server 2016 Enterprise box. We'd like to upgrade to a more recent version of visual studio SS Data tools. Is there any reason we can't do our development in Visual Studio 2019 (SSRS and SSIS packages) and then deploy them to the 2016 production instance?

  I don't know of any reason myself, but I'm not ashamed to admit I don't knbow what I don't know.

  Thanks

  Craig

• Jo Pattyn

  SSC-Dedicated

  Points: 32470

  More actions

  March 29, 2022 at 9:44 am

  #4007546

  With VS 2019 you can target SSIS to 2012,2014,2016,2017,2019.

  Can't tell you about SSRS as we use reportbuilder instead of VS

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  March 29, 2022 at 11:23 am

  #4007589

  You should be fine. Just make sure that you set things up in your SSDT Project Properties to target the right platform.

  ---