dbTalk Databases Forums  

Generate script for few objects only using SqlPubWiz.exe (command line)

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Generate script for few objects only using SqlPubWiz.exe (command line) in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
omtechguy
 
Posts: n/a

Default Generate script for few objects only using SqlPubWiz.exe (command line) - 05-01-2011 , 03:55 AM






Hi,

I am using SqlPubWiz.exe command line to generate scripts for entire
database but i couldn't find a command line parameter that will allow
me to generate script for few objects only and not for the entire
database. for specific object i am using the GUI but i want to do it
using a command line for automation....

Can someone help with that?

Reply With Quote
  #2  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Generate script for few objects only using SqlPubWiz.exe (command line) - 05-01-2011 , 04:11 AM






omtechguy (omtechguy (AT) gmail (DOT) com) writes:
Quote:
I am using SqlPubWiz.exe command line to generate scripts for entire
database but i couldn't find a command line parameter that will allow
me to generate script for few objects only and not for the entire
database. for specific object i am using the GUI but i want to do it
using a command line for automation....
I have not used the Wizard on command-line, but since this a "bonus tool" so
to speak, it may not have that capability. You may reached the point where
you need use Powershell or similar for your work.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.