LINKS
SITE FEED
Support Forum
The fastest and most effective to get answers to your questions quickly. Click Here for more info.
FAQs 
Quick answers to common questions. Click Here for more info.
Troubleshooting
Known issues and basic troubleshooting techniques for problems or unexpected behaviors. Click Here for more info.
Knowledgebase
Technical tips, How-to articles, and other tutorials about ApexSQL Tools. Click Here for more info.
Online Documentation
All of our help files for download or convenient viewing online. Click Here for more info.
Videos
Watch product demos, training videos, or tutorials of our products' main features. We frequently upload new videos so check often for updates. Click Here for more info.
|
ApexSQL Knowledgebase Tips and How-to Articles for Apex SQL Tools Tech Tip: Using Row Filter Feature in ApexSQL Diff (Data) DESCRIPTION This tip describes how to use the Row Filter Feature in ApexSQL Diff to limit the comparison to a specific subset of rows. SOLUTION Use the rows filter to limit the number of rows to be loaded at the same time if your goal is to only compare a subset of data. To do this, simply make use of the Filter column in the Object Filter > Data Tables grid.  For example, if we add this filtering to the Address table of the AdventureWorks database (and to the database it is being compared with), only rows with AddressID < 20 will be loaded. The filter column is especially helpful when the tables you are dealing with include an "updated date" column. This way, you can just load records for a specific date/time range (e.g. load only records updated within the last two days). The Row Filter dialog consists of two panes. On the left pane, you can enter a WHERE clause that will filter the data in the column of the Source object. You can use a different row filter condition on the Destination object. In cases, where you want to use the same condition on both tables/views, you can simply check the “Use the same filter condition for both objects” option. If this option is checked, you only need to type your condition once. ApexSQL Diff will automatically apply the filter on both objects during the comparison. Click on the OK button to save your row filter condition and close this dialog or click on the Cancel button to discard your settings. AUTHOR Janice Lee LAST REVIEW DATE 8 August 2007 Labels: Apex SQL Diff |
© 2008 Apex SQL Tools All Rights Reserved | 1.919.968.8444 | Contact Us | Terms of Use