Here at TwinsSolutions.net we have a whole bunch of websites running and therefore we need to have our SQL versioned in Mercurial as well, for this we Script our Database back and forth from production to development every now and then.
For this I have made a PowerShell script that can be run directly from within Visual Studio, no need to leave to get latest scripted version of dev database.
It's configurable within the powershell ps1 file. Give it a try out, and do not be afraid to ask questions - as I am sure it can be improved i many ways.
Scripting your MSSQL with powershell
Here at TwinsSolutions.net we have a whole bunch of websites running and therefore we need to have our SQL versioned in Mercurial as well, for this we Script our Database back and forth from production to development every now and then.
For this I have made a PowerShell script that can be run directly from within Visual Studio, no need to leave to get latest scripted version of dev database.
It's configurable within the powershell ps1 file. Give it a try out, and do not be afraid to ask questions - as I am sure it can be improved i many ways.
https://gist.github.com/boblogdk/6258085
when the file has been added to visual studio, u can just write ".\UmbracoCurrentDB.ps1" in the console window and it will do the magic.
is working on a reply...