Limiting the data to be scripted

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

Limiting the data to be scripted

Postby DAndres109@aol.com » Wed May 14, 2008 11:42 am

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
DAndres109@aol.com
 
Posts: 14
Joined: Sat May 03, 2008 1:25 am
Location: New York

Postby chris.buckingham » Fri May 16, 2008 1:00 pm

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
chris.buckingham
 
Posts: 56
Joined: Mon Jul 30, 2007 1:39 pm


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests