Post reply

Can development in Visual Studio 2019 run on SQL server 2016

  • 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

  • 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

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply