Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
marat
Yak Posting Veteran
85 Posts |
 Posted - 2009-07-30 : 00:49:13
|
| Hi guys,I was searching the web for a few days and couldn't find any references on how to automate "Generate SQL Server Scripts Wizard" on MS SQL Server 2008.In MS SQL Server 2005 there was an option of using Pub Wizard command lineexec master.dbo.xp_cmdshell 'C:\"Program Files"\"Microsoft SQL Server"\90\Tools\Publishing\SqlPubWiz.exe script ' -d DatabaseName -S ServerName -f -q -schemaonly D:\MSSQL_Backup\mssqlscripts\DatabaseName\Database_name.sqlMy question is: Can I achieve the same results on SQL Server 2008 and how?Thank you |
|
|
|
|
|
automating "Generate SQL Server Scripts Wizard"