We are getting a lot of customers interested in using SQL Toolkit for deploying database updates to remote customer sites. Using SQL Toolkit you can distribute a single executable to your customers and use the Toolkit to do a schema comparison and then automatically update the customers database with the differences between a snapshot from your database and the customers database.

Up until now I haven't used SQL Toolkit that much so I thought it would be nice to learn more about the product and come up with my own example of using SQL Toolkit to deploy/update a database. A recent survey and some helpful existing customers have given me an insight into what people want such an example to do so in the next few days I intend to post my first attempt and then make improvements to it over the coming weeks.

The SQL Toolkit provides full api access to the Red Gate comparison tools giving you database schema, data and packaging functionality in your own applications. You can download a free 14 day trial of SQL Toolkit.