Roy Osherove

View Original

Team Data and the Database publishing wizard

Update: Sachin from the DB Pro team has alerted me that indeed creating the script is possible with DB Pro edition. Coolness! BTW - he just published a white paper on using DB pro to write database unit tests. This is something very powerful in potential, but there is still much work to be done in this area in terms of usability and maintainability of tests.

The all new "Data Dude" for Team System is amazingly cool and people who see it for the first time love it.

I got a question from a potential customer the other day: "Will I be able to create and deploy a single script for my database that I can run on my server to deploy a new DB from scratch, that will also run all the objects based on their dependencies?"

 

The only answer I have for now is "no". I'm still looking for someone to tell me if that's at all possible, but I don't think it is.

However, the new "Database publishing wizard" should come in handy for just such situations, I would imagine:

http://www.microsoft.com/downloads/details.aspx?FamilyID=52D6E741-A4E9-4AC5-9877-F4BC0BD06B55&displaylang=en

"SQL Server Database Publishing Wizard enables the deployment of SQL Server databases into a hosted environment on either a SQL Server 2000 or 2005 server. It generates a single SQL script file which can be used to recreate a database (both schema and data) in a shared hosting environment where the only connectivity to a server is through a web-based control panel with a script execution window. If supported by the hosting service provider, the Database Publishing Wizard can also directly upload databases to servers located at the shared hosting provider.
Optionally, SQL Server Database Publishing Wizard can integrate directly into Visual Studio 2005 and/or Visual Web Developer 2005 allowing easy publishing of databases from within the development environment."