Versions Compared

Old Version 2

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 3

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Before comparing the content of two databases, Idera IDERA SQL data compare Data Compare will analyze the schemas of both databases (or the selected tables). If you manually map the tables between the two databases, Idera SQL data compare 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 the data compare.

...