Publishing/Deploying database project using SSDT

In order to deploy a database using SQL Server Data Tools (SSDT) choose the publish option from Build Menu or right click on the project and select publish. On selecting Publish, it will bring up a dialog box where you can specify the Target Database Settings.

In order to save these publish settings and add it to the current solution, check "Add profile to project". You can have multiple profiles added to the project.

 

Once all options are specified...hit Publish and it will deploy the database project to target server!!!

Comments

  • Anonymous
    March 21, 2012
    Thanks, very useful information