Once I have a database project in Visual Studio, if I edit a stored procedure or view, how do I apply the changes to the server?

Once I have a database project in Visua开发者_高级运维l Studio, if I edit a stored procedure or view, how do I apply the changes to the server?

Solution Explorer ... Right Click Project ... Open properties .. Build tab ... Set target db to your server.

Then back to Solution Explorer ... Right click ... Rebuild ... then when done Right click and Deploy.

Job done :)

Kindness,

Dan