Visual Studio 2019 database project

Question

Visual Studio 2019 database project

Darryl Hoar 181

I have a Sql Server database. I have created a Visual Studio 2019 database project for this database. In the database project, when I make changes to the Stored Procedures, how do I generate a new database with these new versions of the stored procedures. thanks.

Accepted answer

0 additional answers

Your answer

Answer 1

Greg Low 1,980 Microsoft Regional Director

You use the option on the Build menu, to build the project.
That will output a .dacpac file. (You can see where that is located by looking at the text in the Output window at the bottom, as it shows the result of the Build).
You can then deploy a .dacpac to a database using a variety of methods, but one is to use SQL Server Management Studio (SSMS), connect to the server, then right-click on Databases in Object Explorer, and choose Deploy Data-tier Application. A wizard then walks you through the deployment.

Darryl Hoar 181 Reputation points

2024-02-15T14:47:31.5833333+00:00

Import Data-tier application is looking for a BACPAC file not a DACPAC file.
Greg Low 1,980 Reputation points Microsoft Regional Director

2024-02-16T00:21:15.12+00:00

Hi Darryl, I've updated my answer. There are two menu options side by side. In this case, you want the Deploy option not the Import option. dacpacs and bacpacs are basically identical. The only difference is that bacpacs can contain data as well as schema. dacpacs can only have schema. So you need to use the "Deploy Data-Tier Application" option rather than "Import Data-Tier Application".
There are many other ways to do this as well. 1. You can just use the publish option from VS if it has connectivity to the DB. (In many cases people don't as it's in a different environment). 2. You can manually create a database, then use the Tools > SQL Server > Schema Compare option in the DB project to compare the project to the DB, and then use the Update option to push the changes across. 3. You can use the sqlpackage command line tool to deploy it. 4. There are options in Azure Data Studio (ADS) for deploying as well.

Share via

Visual Studio 2019 database project

0 additional answers

Your answer