New Delivery Model for SQL Server Data Tools in Visual Studio 2019

I am using VS2019 Community Edition for SSDT only.  One thing that is not clear to me from reading through the EULA for Visual Studio 2019 Community Edition is whether or not SSRS and SSIS objects specifically can be developed in VS2019 Community Edition and then deployed to an Enterprise/production environment.  Would developing with SSDT in VS2019 Community Edition and deploying to a production environment be allowed under the EULA or would we need to use a full version of Visual Studio for deployment to production if it is ONLY used for SSDT?

wcos_ , does the target server version of your SSIS project match with the version of the component? From example, if you install a component for SQL 2019, you must make sure your project is targeted to SQL 2019, too.

I've verified at least file watch task (http://www.sqlis.com/sqlis/post/File-Watcher-Task.aspx) works fine on my side.

I wanted to install some custom SSIS components from http://www.sqlis.com/ but run into a weird problem: has anyone been able to add custom components to the SSIS toolbox in Visual Studio 2019? The components simply don't show up in the SSIS toolbox.

I the past (I come from the BIDS days) you would just right click on the SSIS toolbox and select "Choose Items". This would then open the Choose Items dialog and add a specific tab for SSIS components.

If you do choose items now from the top menu, it only gives you the 4 regularer tabs (.net, COM, Universal and WPF  components) and it allows customizing only the regular toolbox, not the SSIS toolbox.

Googling has brought me nowhere, as if no one has encountered this problem yet? Which I find hard to believe :).

Anyway any help getting custom components to show up in VS 2019 would be appreciated.

E2Patrick you can use those coming in-box with VS install as long as you are doing SQL development. 

SagittariusA I checked with VS team. The pro and enterprise editions can be activated in an offline environment by using a product key. 

SagittariusA yes, that is for the licensing service. Before that you also need to sign in first, so you will need to open those for sign in as well. 

For offline activation, I will check with VS team. For VS related questions, I would suggest you try asking on https://developercommunity.visualstudio.com/spaces/8/index.html. 

Tim.Chen 

You said;

@@Sagittarius I checked with VS team, in the doc page the section named "Identity badge" also applies for the licensing scenario. 

My reply;

Thanks,  so "Identity badge" section in the URL you referenced previously is the minimal port openings needed so vs2019 can phone home with license info so vs2019 does not self deactivate.

You said;

For other options, maybe you can consider using a commercial license of VS 2019 like the enterprise edition? 

My Reply;

It was my understanding that all editions of VS2019 phone home with license info and that there is no provision for license key entry in any edition?  Is this not true?

Thanks,

SagittariusA

SagittariusA I checked with VS team, in the doc page the section named "Identity badge" also applies for the licensing scenario. 

For other options, maybe you can consider using a commercial license of VS 2019 like the enterprise edition? 

Tim.Chen 

Topic VS2019 Community edition on a secure network.

On inspection.  No indication of what specific URI/Port/trusted end point for licensing scenario  phone home, unless they are all to be opened (Yikes?). 

Just an FYI.  We have no use for VS2019 any edition, we would just like to use the data tools when working with our Enterprise class SQL Servers.  However it appears that Microsoft is pushing VS2019 as the GUI for these tools and perhaps others.  Additionally VS2019 Community Edition while allegedly "free" requires a license to operate even on a secure network (no manual license codes can be applied).  This is will have a profound impact on purchasing/leasing backend Microsoft products for secure venues. 

Is there any other options we may pursue?  There was at one time an on premises licensing server that Microsoft once had if I'm not mistaken? 

Looking for options here.

Thanks so much for your help!

SagittariusA you may want to look at this: https://docs.microsoft.com/en-us/visualstudio/install/install-and-use-visual-studio-behind-a-firewall-or-proxy-server?view=vs-2019