How-To Articles

Re: SQL Server Database Publishing Wizard Community Technology Preview 1

xmldeveloper — Thu, 04 Jan 2007 13:54:14 GMT

If you are interested in SQL Server Database Publishing Wizard you may want to read this great tutorial: Recipe: Deploying a SQL Database to a Remote Hosting Environment (Part 1)

Re: SQL Server Database Publishing Wizard Community Technology Preview 1

danwinn — Thu, 30 Nov 2006 21:32:58 GMT

Thanks for downloading and trying out our first CTP! We released the second CTP earlier this month. It now has a GUI and supports most object and data types.

Check it out at http://www.codeplex.com/sqlhost and let us know if you have any feedback.

Thanks,

Dan Winn

Senior Program Manager

SQL Server, Microsoft Corp.

SQL Server Database Publishing Wizard Community Technology Preview 1

xmldeveloper — Mon, 16 Oct 2006 19:17:29 GMT

I tested it and here are my first observations:

It's a command line tool.
To script the AdventureWorksDW database:

I opened a command promt and change the directory to C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\
I typed the following: sqlpubwiz script -d AdventureWorksDW C:\AdventureWorksDW.sql
Unfortunatelly it failed due to an unsupported data type (the XML data type) for a table:
The limitation was known: DPW Support Matrix
I tried with Northwind database typing: sqlpubwiz script -d Northwind C:\Northwind.sql and this time it worked just fine:

Conclusion: pretty good tool at this stage (CTP1) but you should know that it has its limitation such as a limited set of objects supported and several unsupported data types (XML, Varbinary(MAX), VarChar(MAX), NVarChar(MAX) etc.)
In November the CTP2 should be lauched with a GUI version of the tool and enhanced object and data types support.