Red Gate forums :: View topic - SQL Data Compare 9 - Only sync the last X months of data
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

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

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
brian.chiu.rt



Joined: 07 May 2012
Posts: 2

PostPosted: Tue May 08, 2012 1:12 am    Post subject: SQL Data Compare 9 - Only sync the last X months of data Reply with quote

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
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Wed May 09, 2012 10:24 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group