Database versioning is always hard and here i will demonstrate an idea to make versioning of database automated and in only few minuets
Setup the Environment:
First head fast to SubSonic at CodePlex and download the bits
Generating Database Scheme
fire standard command line tool and run the following command which is self explanatory
C:\Program Files\SubSonic\SubSonic 2.0.3\SubCommander>subsonic version /server localhost /db Northwind /out C:\DatabaseVersionArchive
Test the output directory you will find two files for your scheme and the data as well
Automation
Now from Visual Studio head to your property page of your website and go to the Start Option tap and choose the to run the above line as external command (Think batch file).
Happy versioning :)