Exclude table data from SQL Packager using CLI

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

Exclude table data from SQL Packager using CLI

Postby JackLocke » Mon Jul 09, 2012 9:52 pm

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
JackLocke
 
Posts: 17
Joined: Wed Jun 13, 2012 7:06 pm

Postby peter.peart » Tue Jul 10, 2012 10:11 pm

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
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Re:

Postby JackLocke » Tue Jul 10, 2012 10:22 pm

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.
JackLocke
 
Posts: 17
Joined: Wed Jun 13, 2012 7:06 pm


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests