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

brian.chiu.rt

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

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.