How to publish a SQL Server database project using Visual Studio 2017?

Hi Readers,

In this article, you are going to learn how to publish a SQL server database project using visual studio 2017?

To know how to create a SQL Server database project using visual studio 2017 then first see this article and then come back here.

Step 1: Right-click on your database project and select Publish
Step 2: It opens a publish window,

Step 3: For this example, I am going to publish this database into my local, First click on the EDIT button and it opens again a new window, Switch to Browse tab, and then click on LOCAL, and here it shows our single server instance names. Select your working instance,

Note: You have to select Authentication, but for this example, I am using windows authentication. To test the connection, click on Test Connection and if it shows Test Connection succeeded then proceed to click OK or else check your server and other details.

Note: SSMS should install in your system before publishing the database.
Step 4: Customize your database name

Step 5: Click on Publish
Note: You can see the status inside “ Data Tools Operation” and if showing you “ Publish completed successfully” then open your SSMS and connect to your selected server instance and see whether the newly published database added or not.

If any error while publishing then click on View Results and see the actual error which you can see inside “ Data Tools Operations”.

To see pictures for each step then please visit my blog which has images for this article.

Hope you like this article, Thanks for being here and learned through this.

Happy learning:)

Originally published at https://techinuthan.blogspot.com.