How to Compare Two Databases After Migration (0/3) - An Overview

After migrating a database, you might want to know the differences between source and target database, if there's any loss, you can take actions right away. Furthermore, the source database could be vanished after a period of time, you will never see the original version of data by then. You should compare the two database right away.

There are a lot of tools can help you to do the database comparison, like SQL Developer, TOAD for Oracle, etc. If the target or source database is a large-scaled one, you can divide the comparison work into fractions.

• Metadata comparison: As I mentioned above, there are several tools can do the comparison.
• Data comparison: Tools might not help a lot, so we should compare by ourselves. One of the comparing items is to compare the rows of tables.

In the other articles, I will demonstrate some ways to compare the database that tools could not do.

• How to Compare Two Databases After Migration (1/3) - Comparing Initialization Parameters
• How to Compare Two Databases After Migration (2/3) - Comparing Row Counts by Leveraging Statistics
• How to Compare Two Databases After Migration (3/3) - Comparing Row Counts by Actually Counting