Compares and synchronizes SQL database content.
Moderators: Chris Auckland, David Atkinson, richardjm, david connell
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?
- Posts: 2
- Joined: Mon May 07, 2012 8:19 pm
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.
for more info.
I hope this helps.
- 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