When comparing schemas on different MySQL servers, some incompatibilities can occur in schema objects. For example, when comparing schemas on MySQL 3.23 and 5.x. Schema on MySQL 5.x can have such objects as views, triggers, stored routines that are not supported on 3.23 server. This topic describes how dbForge Fusion for MySQL treats such incompatibilities.
If source schema contains objects that are not supported on the target MySQL server, they are not displayed in the Schema Comparison document and are not affected by synchronization.
If target schema contains objects that are not supported on the source MySQL server, they are displayed in the document. Their default operation is None and they will not be affected by synchronization. You may change their operation to Drop, so the object will be dropped from the target schema.
Sometimes there are some incompatibilities even if the type of the database object is supported on both source and target database. For example, tables are supported by both MySQL 3.23 and MySQL 5.x, but a table on one server may have a column of a type that is not supported on the other one.
When an object is supported on the source server but is not supported on the target server, it will have Inconsistent status and cannot participate in synchronization. When there is an object in the target that is not supported in the source, but source objects are supported on the target server, target schema can be synchronized and incompatible database objects have Different status.
Here are some examples of such incompatibilities:
Partitioning is treated in another way than other incompatibilities. Let us examine several situations:
If target schema supports partitioning, partitioned tables are included into schema comparison results, otherwise they are ignored.
In cases when equal schema objects have syntax differences, because they are placed on different server versions, the object DDL is generated according to target object DDL.