FYI: IF YOU HAVE RECEIVED MULTIPLE OF THESE, I'M SORRY SOURCEFORGE KEPT BLOCKING THE EMAILS DUE TO THERE SIZE.
Everyone,
My company has been using NAnt with CruiseControl.Net with great success for some time now, so much so that it has gotten to the point where we can't live without the automation they bring to our configuration management environment. Automated deployment is a god-send. That said, we were recently successful in bringing much the same environment and process to our SQL Server group with the help of a third-party tool called DBGhost. DBGhost provides an API with its toolset which has allowed us to create a NAnt task to automate the database creation, comparison, and syncronization process necessary to automate our SQL Server build and promotion process.
In general, we follow a very similar pattern of integration as our .Net and other platforms. Using CruiseControl.Net we monitor our VSS repository ($/SQLServer/MyDatabase). When changes occur, the VSS task is executed to get the source, which is then used to create the new, VERSIONED, database. If all scripts complete successfully, the target database in our integration environment is syncronized with this new database. If all is well in the end, VSS is labeled and we move on our merry way. Otherwise, the same notifications available from CruiseControl are ready and waiting for us, including CCTray, error/warnings in the dashboards build report, and a note to your parents.
You will need to register for and download an evaluation version of DBGhost to use and compile the task. Here is the syntax to create the CCW's for the DBGhost APIS:
tlbimp /namespace:Interop.DBGDBBuilder DBGDBBuilder.dll /out:Interop.DBGDBBuilder.dll
tlbimp /namespace:Interop.DBGCompAndSync DBGCompAndSync.dll /out:Interop.DBGCompAndSync.dll
Ryan Cromwell
Senior Systems Analyst 1.1.61299.0
Speedway SuperAmerica LLC
937.865.7856
database.build
Description: Binary data
DBGhostTask.cs
Description: Binary data
