How can we help you today? How can we help you today?

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

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
0

Comments

1 comment

Sort by
  • Chris Auckland
    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 Auckland
    0

Add comment

Please sign in to leave a comment.