How to configure the Database Project to Update the Target Database when you build and deploy the Project?

Step 1:

                Right-Click on the Project in the Solution Explorer and select Properties.

Step 2:

                In the Properties Window Select the Deploy Tab (Refer to Pic below)

Step 3:

                From the Deploy Action drop down select the option “Create a Deployment script (.sql) and deploy to the database”

Step 4:

                Click on the Edit button next to the Target Connection option and select the Target Database


That’s it, now you are all set to make changes to the Script and Deploy it and expect the changes to be applied to the Target Database