SQL Data Compare 9 - Only sync the last X months of data

Compares and synchronizes SQL database content.

Moderators: Chris Auckland, David Atkinson, richardjm, david connell

SQL Data Compare 9 - Only sync the last X months of data

Postby brian.chiu.rt » Tue May 08, 2012 1:12 am

With SQL Data Compare 9, is it possible to only sync the last 3 months of data for certain tables?

We want to use Data Compare to do a data extract weekly and for some tables we only wants the last 3 months worth of data.

Is this something that is doable with SQL Data Compare 9?

Thanks,
brian
brian.chiu.rt
 
Posts: 2
Joined: Mon May 07, 2012 8:19 pm

Postby Chris Auckland » Wed May 09, 2012 10:24 am

Yes, you can add a SQL 'where' clause to each table, to filter the data you're synchronizing. You can configure this on the 'Tables & Views' tab.

See here for more info.

I hope this helps.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests