Just the data please.

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

Just the data please.

Postby StormRider » Mon Mar 26, 2012 10:19 pm

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>
StormRider
 
Posts: 14
Joined: Thu Nov 10, 2011 2:20 am

Postby andy.campbell.smith » Wed Mar 28, 2012 3:39 pm

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
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby StormRider » Wed Mar 28, 2012 9:01 pm

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.
StormRider
 
Posts: 14
Joined: Thu Nov 10, 2011 2:20 am

Postby andy.campbell.smith » Thu Mar 29, 2012 11:21 am

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

http://www.red-gate.com/supportcenter/g ... d_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
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests