ASP.NET 4 Unleashed

Deploying Databases

Although it’s certainly a huge productivity increase and a time and stress saver, it sure would be great if we could correlate our database migrations with our application deployments.

The folks at Microsoft have thought of this as well. There is a Package/Publish SQL tab on the project properties page now. This enables you to create a list of database deployments in a grid. For each of those deployments, you can define a source database and a destination database. You can also choose whether the deployment includes schema only, data only, or both. Also keep in mind that all this information is also on a per-configuration basis, so the list of databases and their source/target pairs will be different depending on whether ...