September 8, 2016 at 9:04 am
I have a HQ server and Office_location server. we have a replication application that moves new/updated data from HQ to Office and/or Office to HQ.
We have noticed that we are missing some records from one or the other location also we are sometime seeing a record in both locations but one is not matching the other.
Is there any FREE(CHeap) tools that i can do a data matching/validation.
September 8, 2016 at 10:01 am
I don't know a free tool that does this.
Redgate SQL Data Compare[/url] will do exactly what you need.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 8, 2016 at 10:10 am
i have sql compare, i forgot one thing. we have a time offset between hq and offices which is handled in our custom replication. example a record has a update of 01/01/2015 03:15:01 :259 the office is 4 hours ahead of HQ so when the record comes in to confirm if a record is newer we would subtract 4 hours from the records update date/time.
do you know if there is a way to add or subtract the offset?
September 8, 2016 at 10:40 am
Yeah, actually, you can add a WHERE clause to the filter so that you add that value for the comparison. The version I checked this on is 11.6.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply