How to build multiple database versions from the same source: post-deploy scripts

In Part 2 of his series, Alex Yates shows how to use a combination of post-deployment scripts to handle cases where a code object exists in multiple production instances, but in different states. Read more

SQL Compare
Database Builds and Deployments
Database Source Control

How to build multiple database versions from the same source: object filters

How to use filters in SQL Compare to avoid deploying objects that exist only in the source to databases where they may not be required or appropriate. Read more