SQL 2008 SQLPUBWIZ Command Line Failure
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I'm running sqlpubWiz from the command line to script my database. This command line worked with SQL 2005 - I have changed to 2008 and have got the latest version of SqlPubWiz (as far as I know - it's in the folder C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\1.2 I run
sqlpubwiz script -d mydatabsename-S localhost\mydatabase -f test.sql -targetserver 2008All looks well - it starts with "Gathering List of Objects to Script" then changes to "Scripting Objects" and starts printing dots to show progress... then stops with Error: Operation is not valid due to the current state of the object. Funny thing is that it works fine if run through the GUI. I'm all out of ideas..... Help.\\axxx