How does the program compare database schemas?
The utility compares tables item by item: if the names of tables are equal program compares the lists of columns. If the names of two columns are equal, it compares their types, sizes, decimal digits (if applicable), nullability, default values, check constraints, comments (or MS_Description for SQL Server if available) primary and foreign keys.
For other database objects, the program compares the SQL scripts of procedures, triggers, views, etc.
Note: indexes and triggers associated with a table are placed in a separate sub-tree and the program compares them independently of their table.
There are three comparison and synchronization levels:
* - not compatible with console mode.
"system" exclude filter means "system124", "my_system" or "my_system124" tables will not be included in the schema tree.
"order" include filter means "coord" or "nord" tables will be skipped during schema tree building.