Red Gate forums :: View topic - Limiting the data to be scripted
Return to www.red-gate.com RSS Feed Available

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

Limiting the data to be scripted

Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
DAndres109@aol.com



Joined: 03 May 2008
Posts: 14
Location: New York

PostPosted: Wed May 14, 2008 11:42 am    Post subject: Limiting the data to be scripted Reply with quote

Hi,

Are there any plans to allow per-table filtering of the data to be scripted (possibly by means of a query or list of keys)?

Such a feature is incredibly helpful when you need to create a fresh-start database.

I am aware that this can be done via the post script functionality of the product.

Thanks,

David Andres
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
chris.buckingham



Joined: 30 Jul 2007
Posts: 56

PostPosted: Fri May 16, 2008 1:00 pm    Post subject: Reply with quote

There aren't any plans for placing this functionality in Packager, but you could use SQL Data Compare + SQL Compare + Packager to do this instead.

Step 1) Create a schema for the source database using SQL Compare by comparing it to an empty target, synchronise to the target and you will have an empty database schema as the target database.

Step 2) Run SQL Data Compare against the source comparing your per-table views of the source to the target, and again sychronise to the target. This will populate the target with the selected data.

Step 3) Run Packager on the target and create the package. This will contain selected data to your requirements.
_________________
Chris Buckingham
Red-Gate support
Back to top
View user's profile Send private message Send e-mail
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