--- title: "Team Data and the Database publishing wizard" url: "https://osherove.com/blog/2006/12/20/team-data-and-the-database-publishing-wizard.md" canonical: "https://osherove.com/blog/2006/12/20/team-data-and-the-database-publishing-wizard.html" published: "2006-12-20T15:36:29" updated: "2006-12-20T15:36:29" tags: [".NET", "Team System"] author: "Roy Osherove" description: "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…" usage: "Licensed under CC BY 4.0 — reuse, quote and adapt with attribution (Roy Osherove, link to the original page)." license: "https://creativecommons.org/licenses/by/4.0/" --- # Team Data and the Database publishing wizard By Roy Osherove December 20, 2006 In [.NET](https://osherove.com/blog/category/net), [Team System](https://osherove.com/blog/category/team-system) **Historical article** · Originally published December 20, 2006; technical details may be outdated. **Update**: [Sachin](http://blogs.msdn.com/sachinre/) 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](http://blogs.msdn.com/sachinre/archive/2006/12/20/database-unit-testing-whitepaper-draft.aspx) 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](http://msdn2.microsoft.com/en-us/teamsystem/aa718764.aspx)" 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](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." ## More in .NET [All posts in .NET](https://osherove.com/blog/category/net) - Jan 29, 2007 ### [Cheat Sheets for ASP.NET, Regex, Mock Objects and more](https://osherove.com/blog/2007/1/29/cheat-sheets-for-aspnet-regex-mock-objects-and-more.html) - Jan 7, 2007 ### [Shell MegaPack version 8.0 is out](https://osherove.com/blog/2007/1/7/shell-megapack-version-80-is-out.html) - Dec 14, 2006 ### [Catch me talking Agile at the Israeli .NET Architects user group](https://osherove.com/blog/2006/12/14/catch-me-talking-agile-at-the-israeli-net-architects-user-gr.html) - Dec 14, 2006 ### [Vote for the top talks to see at the upcoming MS Israeli Conference](https://osherove.com/blog/2006/12/14/vote-for-the-top-talks-to-see-at-the-upcoming-ms-israeli-con.html) --- ## About the author **Roy Osherove**: Senior Solutions Architect at AWS working on AI for production and AI-driven development; author of The Art of Unit Testing and Elastic Leadership, with about 20 years of consulting and training on unit testing, TDD, team leadership and continuous delivery. ### Sites - [RobotPaper](https://robotpaper.ai/): This blog: AI patterns and anti-patterns, AI and coding agents, and engineering leadership. - [osherove.com](https://osherove.com): Roy's personal site. Author of The Art of Unit Testing and Elastic Leadership; consulting and training on unit testing, TDD, team leadership and continuous delivery, plus about 20 years of blog posts. - [The Art of Unit Testing](https://www.artofunittesting.com): The Art of Unit Testing, 3rd Edition (Manning): readable, maintainable, trustworthy unit tests, plus TDD workshops in C#, JavaScript, Java and Kotlin. - [5whys.com](https://www.5whys.com): Roy's writing on software team leadership: self-organizing teams, surviving chaos, learning mode and the Elastic Leadership model. - [Pipeline Driven](https://pipelinedriven.org): Continuous delivery and DevOps practices: build patterns, pipeline-friendly testing, DevOps metrics and enterprise DevOps. - [Elastic Leadership](https://www.elasticleadership.com): Elastic Leadership, Roy's framework for software team leaders (survival, learning and self-organizing modes). ### Social - X: https://x.com/royosherove - LinkedIn: https://www.linkedin.com/in/osherove/ ### Contact - Contact form: https://forms.gle/jQSx5KoXvrVA1JCK7 ### License Licensed under CC BY 4.0 — reuse, quote and adapt with attribution (Roy Osherove, link to the original page). License: https://creativecommons.org/licenses/by/4.0/