Welcome to Sign in | Help
in Search

SQL Server Database Publishing Wizard Community Technology Preview 1

Last post 01-04-2007, 3:54 PM by xmldeveloper. 2 replies.
Sort Posts: Previous Next
  •  10-16-2006, 10:17 PM 402

    SQL Server Database Publishing Wizard Community Technology Preview 1

    I tested it and here are my first observations:

    • It's a command line tool.
    • To script the AdventureWorksDW database:
      1. I opened a command promt and change the directory to C:\Program Files\Microsoft SQL Server\90\Tools\Publishing
      2. I typed the following: sqlpubwiz script -d AdventureWorksDW C:\AdventureWorksDW.sql
      3. Unfortunatelly it failed due to an unsupported data type (the XML data type) for a table:
      4. The limitation was known: DPW Support Matrix
      5. 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.

     


    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
    Filed under:
  •  11-30-2006, 11:32 PM 1147 in reply to 402

    Re: SQL Server Database Publishing Wizard Community Technology Preview 1

    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.

  •  01-04-2007, 3:54 PM 1473 in reply to 402

    Re: SQL Server Database Publishing Wizard Community Technology Preview 1

    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)
    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems