Page History
To start a comparison between select tables and/or indexed views click on the IDERA SQL Data Compare Data compare, by default, maps Oracle tables on two schema by name. To map them manually, click Compare Tables/Views button on on the "Home" tab of the ribbon. On the Object Compare dialog window that appears you can first select the servers Oracle connections and databases schemas on which the objects you wish to compare reside. In case When there is a large number of objects in those databases you may wish to specify a pattern for the name of the objects you are looking for (ex. all tables that start with "a"). That will make makes it easier to find those objects.
...
IDERA
...
Data Compare for Oracle Database, in addition to tables,
...
can compare views
...
. The
...
Compare and Synchronize Views option determines whether views should be included in the comparison and synchronization. However, use this option with caution. There are
...
limitations that
...
Oracle imposes on views
...
and not all views are updatable
...
.
Once you have made make your selections above you can , click on the Read Database Objects link. IDERA SQL Data Compare compare will read the schemas of the two databases objects on each schema and populate the two left bottom windows with the list of tables / views available.
Now you can map those objects one at a time irrespective of the object names. Select an object on the left, then select an object on the right, and then click the left to right "arrow" button to map those two objects.
| Info |
|---|
The SQL Data Compare Comparison Options comparison options will affect the ability to compare the objects. For If, for example, if you clear cleared the Compare and synchronize tables option option, then while you cannot compare the tables but can only view and map themcan still see and map the tables they will not be compared. The same holds true for indexed views which by default are not included in the comparison. |
| Excerpt |
|---|
Total compare from data to schema with IDERA SQL Comparison Toolset. Learn more > > |
...