System-i DBcompare Lite

DB Compare helps you compare the structures of two different databases. The first level of comparison is that of all the tables; the second is field-by-field. Please note that comparison will be made only for the structure (tables and fields) and not for the field content.

Supported database types are:

• MySql
• RealServer
• CubeSQLServer
• SQLite

Comparison can also be made between two different types of database (e.g., MySQL and SQLite).

The result comes with three levels of alert:

• Table OK - means that the table is nominated in both databases, it contains the same fields and the same type
• Table not OK - means that the table is missing in one of the two databases
• Field not OK - the table contains a difference between one or more fields. Click on the line to see what differences there are (a field may be missing or different type).

Lite version compares only the first 2 tables