Troubleshooting

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

MOST RECENT

I’ve run a comparison but objects I know that are in my database aren’t showing up – what is wrong?

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

Welcome to the ApexSQL Troubleshooting and Known Issues

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

I’ve run a comparison but objects I know that are in my database aren’t showing up – what is wrong?

SUMMARY
There are several reasons why objects that exist in a database may not be displayed in the main screen after running a comparison.

SYMPTOMS
The comparison is completed but objects existing in the database are not displayed.

CAUSE

The object type was not included in the types to be compared. If the type was not included originally, it will not be displayed under any circumstances until the main comparison is re-run with the object type included.
The objects can be filtered out by their Type and comparison result by using the Object Filter Toolbar
The objects can be filtered out by their Name, Schema, Type and comparison result by applying the filters for the appropriate Result Grid columns.
The objects can be filtered out by applying the Difference Code filter.

RESOLUTION
Check that object types and particular objects are selected for comparison. Check that the option Treat Objects Selection as Exclude is not checked at Structure Comparison Wizard->Object Filter tab. Check that objects are not filtered out by the Result Grid column filters by their Name, Schema, Type and Comparison result or by the Objects Filter Toolbar.Verify that objects were not hidden by the Difference Codes Filter settings.

In the following example after two databases comparison had been completed the different Assemblies objects, missing and different Data Type objects, additional Default and identical Route objects were detected:

To Filter the objects by their type we use the Object Filter toolbar:

After Assemblies have been filtered out, the Assembly objects no more displayed in the main grid:

To filter the objects by their Name, Schema, Type and Comparison result the Result Grid column filters can be used:

The result of filtering out all but the missing objects is displayed below:

The object can be hidden by applying the Difference Code Filter:

For example the TestClr Assembly is different in Members:

After deselecting the Members column in the difference code filter and applying the filter the Assembly that was different only in Members attribute is not displayed in the main grid:

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

LAST REVIEW

17 September 2007 Date of Last Review

Labels: ApexSQL Diff, ApexSQL Diff (Data)

...

posted by Irene Sanford on Monday, August 06, 2007 0 comments

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.