Page History

Before comparing the content of two Oracle schemas, data compare performs a mapping of schema objects, i.e. tables and, optionally, views. By default, a table on one schema is mapped to a table on the other schema that has the same name. Depending on the comparison options, views and can also be mapped with each other. If you choose to compare specific tables or views, then data compare honors the manual mapping, compares only the selected objects and ignores the rest of the schema.

Once the object are mapped, data compare analyzes columns and chooses a suitable unique databases, IDERA SQL Data Compare will analyze the schemas of both databases (or the selected tables). If you manually map the tables between the two databases, SQL Data Compare will use that mapping as is and proceed with analyzing the pairs of tables. It you compare whole database it will first perform a automatic mapping of the tables based on their names (owner name + table name) - every table on one database is paired with a table (when possible) on the other database. Then, it proceeds to analyze the pairs of tables to map individual columns, determine the available comparison keys and choose a key that will be used to pair rows during compare the data comparerows.

During this preparation phase you will be able to customize the object mapping, include and exclude certain tables and certain columns within those tables, choose comparison keys and define data filters to compare only subsets of rows from certain tables.

...