Fulfilling my promise at TechEd, I’ve finally completed a self-directed demonstration of the database versioning techniques I first presented at last year’s TechEd and which was alluded to during this year’s TechEd SQL Tricks presentations. It’s published here on my resource page at MSDN Code Gallery. No platform snafus this time, either..
The 12.5mB file contains the following:
To get the full impact of the demonstration, you’ll need to restore the database backup onto a SQL Server 2005 or SQL Server 2008 instance. If you name the resulting database VersioningDemo, the scripts will function without modification.
Examine the contents of the PowerPoint file for an overview of the design considerations which informed this effort. LightweightVersioningDemo.sql offers a trivial demonstration of scripting variables, while HeavyweightVersioningDemo.sql offers a glimpse into the full power of this technique.
HeavyweightVersioningDemo.sql offers a discussion of the schema which enables this approach, as well as an open-ended demonstration which will allow to to instantiate as many version of data and code as you like.
There are detailed instructions embedded in both the Lightweight and Heavyweight scripts.
I hope this demonstration is useful to you, and I appreciate your patience in awaiting its release!
As always, please let me know if you have any questions or comments.