Where is the Data Compare utility?

Hi,

I need to compare some of the tables in Oracle Stage and Prod databases.

But I can't seem to locate the Data Compare Utility, which is mentioned in the manual.

In the Options tabs, we have

Targets
DB Options
Code Formatting
Code Refactoring
Code Snippets
Code Generator
Unit Tests
Data generator
Source control
Schema Compare
About

, but there's nothing there about Data Compare.

It's in the menus in a couple of different places, not in the Options dialog. Start with the right-click menu in your database development environment, then look for Compare Code and Data -> Compare Data

Please delete this post. The manual explains about then number of tables, depending on whether Schema, Database or Object is selected.

Last edited by SqlExplorer on Fri Dec 30, 2022 5:36 pm; edited 1 time in total

Please choose a different comparison scope. For example, Schema scope. Then you can cherry pick specific tables. Table scope is for comparing tables with different names when they cannot be matched by name..

Schema doesn't have any checkboxes. Neither does database. And next is disabled.

Even if you try double-clicking on any of the tables (when schema or database is selected), nothing happens.

Assuming Schema scope... after you expand the Connections tree, select two schemas whose tables you want to compare (same or different servers). Click Next button. Now you can choose tables to compare. Expand Matching Tables folder. This is where you can find tables with matching names, they get mapped automatically. For anything else, expand other folders, see my screenshot below and use drag-and-drop to map them if their names don't match exactly. You can also map columns there too, but it's not usually required, it's for edge case scenarios where column names don't match or there are different number of columns in tables being compared. The following screenshots should help (click the images to enlarge them).

Schema selection

Table mapping

What I'm trying to say, is that there are no checkboxes next to the tables.

Also, how come you have Step 2 of 8, while I have Step 2 of 4?

I'm using Version 12.1.279. But I'll upgrade to 12.2.383 right now.

It looks like you have choosen Schema Compare tool for schema comparison instead of Data Compare. They are adjucent in the same menu.

You're right. I'm going to do both.

Ok, thanks.

Beautiful. What a clear, nicely formatted report.

Thanks for all the assistance.

Ha, punchline - there were a few false positives in the report. It's because the fields in STAGE are in a different order from the fields in PROD.

I notified the DBA team, regarding this.

Great.

Just in case, Schema Compare would be able to catch those and many other schema differences, it can go very deep and analyze all sorts of physical attribute and logical attribute differences, storage, partitions settings, permissions, indexes, procedural code, and so on...

Unfortunately, the Schema compare isn't going to work, but it's not because of Sql Assistant. I don't have the requisite permissions, so it's returning an error.

I don't want to stretch this thread out any further. I had the same problem with another tool.

Everything's good, thanks for helping.