Exclude table data from SQL Packager using CLI

JackLocke · July 9, 2012 4:52PM

Hi All,
We are evaluating SQL Packager to use as a delivery method to provide updates to clients. And usually (in 90% cases) the update is only for database structure change.
So my question is how do I create an exe that includes only database structure changes using CLI of SQL Packager ? Issue is we are running packager using CLI so automate the process, and in list of all switches I don't see any option to create package for either data or schema changes. Package generates via CLI of SQL Packager always includes both schema and data changes.
I can generate package which contains only schema update using GUI. I want to achieve same thing using CLI.

Any suggestion is appreciated.

Thanks,
Jack

peter.peart · July 10, 2012 5:11PM

Thanks for your post. Per the help contents for the tool, to exclude all data objects of a type only specify the type (eg /excludedata:Table).

HTH!

Pete

JackLocke · July 10, 2012 5:22PM

peter.peart wrote:

Thanks for your post. Per the help contents for the tool, to exclude all data objects of a type only specify the type (eg /excludedata:Table).

HTH!

Pete

Thanks Peter,
This is exactly what I needed.

Exclude table data from SQL Packager using CLI

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk