Title Image

SQLDiva

Melissa Demsak's SQL Home Sweet Home

Welcome to SQLDiva Sign in | Join | Help
in Search

SqlDiva

Tech Talk
 
 

How much would you pay for a Utility to script out the base DDL and Data for a SQL 2000/2005 Database?

Over the years, I'm come up with many methods to script out and recreate the base DDL and Data for application databases.  This usually consisted of scripting the individual objects to separate files, writing data into text files and then coming up with a method to rebuild the database.  I kind of like implementing these process', but I have to admit that the development of this stuff can be grueling!!!
 
Now, you don't have to go through the trouble, Microsoft just released the SQL Server Database Publishing Wizard CTP 1  which is a command line utility that scripts out all objects including the data.  Yippee!!!
 
So, I hope you said that you would pay $500+ for this utility.  And if you feel particularly generous, you can place that money in an envelope addressed to “Children of SQLDiva College Fund“!!!
 
Download:
The SQL Server Database Publishing Wizard provides a way to publish databases to T-SQL scripts for later use.
 

SQLDiva

Published Friday, October 20, 2006 1:38 PM by Melissa
Filed under:

Comments

Jason Haley said:

April 11, 2007 7:59 AM
Anonymous comments are disabled
Powered by Community Server, by Telligent Systems