question

SnowyRiver-5084 avatar image
0 Votes"
SnowyRiver-5084 asked EricMurphy-9545 commented

Can you use Visual studio community Data Tools with SQL server Standard Edition

I have SQL Server Standard Edition and want to develop using Data Tools with Visual Studio Community Edition.

I notice that it's allowed with SQL Enterprise editions

Seen here

The EULA of VS 2019 community edition has a specific section that allows enterprise users to use it for the SSDT workload. See https://visualstudio.microsoft.com/license-terms/mlt031819/.
Any number of your users may use the software only for Microsoft SQL Server development when using the SQL Server Data Tools or the extensions “Microsoft Analysis Services Projects”, “Microsoft Reporting Services Projects”, or “SQL Server Integration Services Projects” to develop Microsoft SQL Server database projects or Analysis Services, Reporting Services, Power BI Report Server, or Integration Services projects.


But I can't find anything around right to use VS 2019 Community with SQL 2019 Standard Edition.

sql-server-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SnowyRiver-5084 ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya

0 Votes 0 ·

What you're looking at is the right to allow more than 5 users to use Community Edition if you're an organization. Organizations can only use Community Edition (for more than 5 users) in one of the specific uses listed under that section. If you're not an organization with at least 5 users, you can skip over the part about "If you are an organization".

SQL server itself will limit what you can do based on the version. For example, if you're connecting to SQL Server Express, then SSRS will only connect to itself or other SQL Servers. SQL Server Standard's SSRS will allow the use of data sources with generic ODBC drivers. This has nothing to do with which version of Visual Studio you're using, it's built into SQL Server itself.

0 Votes 0 ·
TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

The developer tools are not licensed based on the server you are connecting too. You can use the VS 2019 community edition + SSDT add-ins to develop on any platform or edition.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @SnowyRiver-5084,

Welcome to Microsoft Q&A!
The standard version is no problem. As TOM said, > The developer tools are not licensed based on the server you are connecting too.
The enterprise you are looking at does not seem to be an enterprise version, but an organization.
Your question is about the license of Visual Studio, you can ask under this link. The forum is more about technical discussions.
https://visualstudio.microsoft.com/support/


Best regards,
Seeya


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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.