Troubleshooting: ApexSQL Diff doesn't show any objects after comparison in Data mode.

LINKS

General

Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Diff
Apex SQL Diff (Data)
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Report
Apex SQL Script

Troubleshooting Home

SITE FEED

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.

Troubleshooting

Troubleshooting and Known issues with Apex SQL Tools

ApexSQL Diff doesn't show any objects after comparison in Data mode.

After data comparison is finished the Main Grid doesn't show comparison results.

CAUSE
There are three most possible reasons why compared objects are not shown in the Main Grid:

The tables(views) have identical data.

The tables(views) are incomparable.

The tables(views) were filtered out by the Object Filter.

RESOLUTION

To verify that objects are identical use the Main Menu->Tools->View Identical Objects command. The Identical Objects dialog displays the objects that were detected identical during comparison:

More information on Identical Objects is available at on-line Help for ApexSQL Diff.

Use the Main Menu->Tools->View Incomparable Objects menu item to view the information about objects that could not be compared for some reason(they have different names and/or schemas and not mapped, for example):

Additional information on Incomparable Objects dialog is available from on-line Help.

The Object Filter settings can filter out the objects by their types. Check that Table(or View) button is pressed at the Data Object Filter toolbar. As shown at the picture below the Tables button released state hides the Table objects.

Look at on-line ApexSQL Diff Help for Data Objects Filter toolbar description.

LAST REVIEW

17 September 2007 Date of Last Review

Labels: ApexSQL Diff (Data)

posted by Irene Sanford on Friday, July 20, 2007

0 Comments: