Red Gate forums :: View topic - Just the data please.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

Just the data please.

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
StormRider



Joined: 10 Nov 2011
Posts: 14

PostPosted: Mon Mar 26, 2012 10:19 pm    Post subject: Just the data please. Reply with quote

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>
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 159
Location: Red Gate Software

PostPosted: Wed Mar 28, 2012 3:39 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
StormRider



Joined: 10 Nov 2011
Posts: 14

PostPosted: Wed Mar 28, 2012 9:01 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 159
Location: Red Gate Software

PostPosted: Thu Mar 29, 2012 11:21 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group