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

Snowy River 21 Reputation points
2021-11-17T12:12:29.73+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,688 questions
{count} votes

Accepted answer
  1. Tom Phillips 17,716 Reputation points
    2021-11-17T13:01:06.53+00:00

    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.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,436 Reputation points
    2021-11-18T06:59:11.507+00:00

    Hi @Snowy River ,

    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.

    0 comments No comments