Just the data please.

StormRiderStormRider Posts: 26
edited March 29, 2012 6:21AM in SQL Packager Previous Versions
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>
· Share on Twitter

Comments

Sign In or Register to comment.