Just the data please.

[StormRider]

I want to use SQL Packager to generate a script that contains specific tables from our production database so my developers can apply live data to their database.

1) There doesn't appear to be any kind of command line option to exclude ALL schema.
2) How do you Exclude Dependencies?
3) Once i managed to exclude all of the schema, I get error:
Error: The selected objects are identical or no objects have been selected in the comparison.

Here's my command line args file:

<?xml version="1.0"?>
<commandline>
<force/>
<verbose/>
<makescript/>

<scriptdestination>c:\data\test.sql</scriptdestination>

<s1>qasql.local</s1>
<db1>prep</db1>
<u1>*</u1>
<p1>*</p1>

<excludeschema>Table</excludeschema>
<excludeschema>StoredProcedure</excludeschema>
<excludeschema>View</excludeschema>
<excludeschema>Schema</excludeschema>
<excludeschema>Role</excludeschema>

<excludeschema>User</excludeschema>

<includedata>Table:AppUser</includedata>
<includedata>Table:AppRoles</includedata>

</commandline>

[andy.campbell.smith]

This is a known bug in SQL Packager, reference SPA-586. There isn't currently a command-line workaround, but you should be able to create data update packages from the GUI - is that an OK workaround?

I've added your details to the bug report, so I'll make sure you get notified when the bug gets fixed.
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer

[StormRider]

Unfortunately no, this is going to be part of an automated nightly process. I'll take a look at SQL Data Compare and see what happens.

[andy.campbell.smith]

You could also try SQL Packager 5 - you can download it from here:

http://www.red-gate.com/supportcenter/generalcontent/all_products/articles/old_versions

I don't think the bug was present in that version, and that might be easier than messing with Data Compare.
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer