SQL Delta Logo
SQL Delta Banner

Data Comparison - Pre filter tables

Support and information about SQL Delta for SQL Server Version 5

Data Comparison - Pre filter tables

Postby dbatton » Wed Feb 26, 2014 11:29 am

In comparing the data between two sql server databases, it takes a long time for the comparison to run through all the records in one very large table.
Assume this table is an entry log table that has a column named "EntryDate" of datatype DATETIME

I could shorten the wait time for the comparison SIGNIFICANTLY if I could enter something like...
WHERE EntryDate >= DATEADD(day, -14, GETDATE())

For a particular table - only looking at the last two weeks (my syntax may not be 100% but you get the idea) instead of the ENTIRE TABLE every time I want to sync data.

Does this feature exist and I am just not finding it, or is this something I that would go on the "wish list" for new releases"?????????????????
dbatton
 
Posts: 2
Joined: Wed Feb 26, 2014 11:02 am

Re: Data Comparison - Pre filter tables

Postby dbatton » Thu Feb 27, 2014 4:19 am

I found the feature it's on the middle tab of the data comparison wizard.
dbatton
 
Posts: 2
Joined: Wed Feb 26, 2014 11:02 am


Return to Support Version 5