Exclude table data from SQL Packager using CLI

JackLocke

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

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

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.