Feature Request: Support for Visual Studio SQL Database Projects

[mattiascibien]

Hello,

At my workplace we use Sql Server Visual Studio Database projects for handling our database developing.

Since SQL Ops seems to be tailored also for devs with its features it will be really nice to have the possbility to open .sqlproj files to provide db dev.

[R-i-c-h-B]

Hi all, wondering how this request it progressing?

Or is it already in and available and I'm just not able to see it working clearly?

As we are progressing on our move towards a leaner more linux based model, I am fighting to retain the SQL Servers - getting a solid SQLProject like dev capability functional and superb is going to be super helpful!

[kburtram]

@R-i-c-h-B We currently have an early DacFX .Net Core port, which is the first step in supporting SQL Project scenarios. We are starting an Export dacpac extension which will be the first DacFX feature we ship. @MattIrv is currently thinking through other SQL developer scenarios such as build\deploy SQL Project or Schema Compare, but we're early in the process. Currently the thinking is we'd prefer to light-up these developer scenarios in VS Code and focus a bit on using Azure Data Studio and VS Code together. Though we don't have anything concrete committed here yet.

[R-i-c-h-B]

@kburtram Sounds good, I hope you can get some prioritization on this side of the tooling.

[joshbooker]

+1 for this! I believe this represents the last remaining bits needed for full SSDT parity.
Namely:

1. Script database to .sql files (create/open sqlproj equivalent)
2. Import .sql files (sqlproj) into Dacpac

There is mssql-scripter x-plat utility for #1. As for the 'database project' stuff, it may be that the existing xplat tools do not do this yet. Someone may have to first recreate or OSS the VSDBCMD.EXE utility for x-plat.

Thanks Team for updating this issue with your current direction.

[dzsquared]

In the September release of Azure Data Studio, we added the SQL Database Projects extension. if you're on v1.22 or greater, this extension will be available to you.
For more information on the extension, here's the docs link: https://docs.microsoft.com/en-us/sql/azure-data-studio/extensions/sql-database-project-extension

The extension is in preview and I'd love to hear about your experiences with it.

[dzsquared]

The combination of SQL Database Projects, Schema Compare, and Data-Tier Application Wizard extensions provides for a cross-platform database development experience in Azure Data Studio. The functionality draws from existing SSDT experiences and incorporates support for new features, such as Azure SQL Edge. SqlPackage.exe and the .NET Core SDK are the foundational technologies behind the interfaces.
While this issue is being closed since the feature asks in this item have been completed, our work on developer experiences continues. Work on Tasks (#10370) is underway and other items can be found under the "Area - SQL Project" label.