SqlPackage.exe can now run your SQL Server schema compare scripts
Posted: (EET/GMT+2)
When your application evolved, likely does your database as well. For SQL databases, Microsoft provides a handy tool called SqlPackage.exe which allows you to automate many SQL Server related tasks, such as updating databases based on schema changes.
Just recently, the utility has been updated, and it can now also run your schema compare (.scmp) files, and report the results. Previously, there was no direct build-int feature to run these, except interactively.
This gives you one more tool to automate deployments.