Take the tour ×  I hope I am not creating any useless post here,
but I actually could not find the solution I was looking for.  I
am currently developing an application that uses 2 SQL Server
databases. These databases will be deployed to customer servers
but will change due to future updates, such as new stored
procedures or fixes.  I am wondering what the best way is to do
that?  In Visual studio it is pretty simple by using Schema
compare, but I cannot require the customers to have visual
studio installed, just because of schema compare functionality.
Is there a simple way to compare databases with C#, by using
.bak backups or online master databases?  Also what would your
suggestion be in deploying databases to customer environments?
Best regards  share|improve this question add comment  1 Answer
up vote 1 down vote accepted  If you are using the SSDT tools
for Visual Studio 2010 and 2012, you can create and deploy
DACPACs with your application. As part of your installation,
upgrade, you can utilize the