Example: Updating a remote customer database schema
Posted by Dave Mellors | Filed under Software Development
Overview
A common use of the Red Gate SQL Comparison SDK is to package up the latest version of a database schema and send it to customers as an executable.
This example demonstrates how easy it is to use the SDK to do this.
NOTE: SQL Comparison SDK is to be the new name for SQL Toolkit
Tags: .net, Red Gate Software, SQL Comparison SDK
Microsoft VHD administrator password
Posted by Dave Mellors | Filed under Fixes to problems
Ha! I just spent the last ten minutes trying to get into a microsoft VHD. The administrator password is contained in the readme file but I just couldn’t get it to work!
Eventually, it dawned on me… keyboard layout!!! The password was pass@word1 and because I am in the UK it was coming out as pass”word1 [...]
Tags: Virtual PC, Virtual Server
SQL Toolkit introduction
Posted by Dave Mellors | Filed under Software Development
In my last post I talked about writing an example application using the Red Gate SQL Toolkit but it occurred to me that I ought to mention a bit more about what SQL Toolkit is and what it can be used for.
Tags: .net, Red Gate Software, SQL Comparison SDK, SQL Server
Red Gate SQL Toolkit: SQL Deployment example
Posted by Dave Mellors | Filed under Software Development
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 [...]
Tags: .net, Red Gate Software, SQL Comparison SDK, SQL Server