When comparing schemas on different Microsoft SQL Server servers, some incompatibilities can occur in schema objects - for example, when comparing schemas on SQL Server 2008 R2 (10.50) and SQL Server 2016 (13.0). A schema on SQL Server 2016 (13.0) can have such objects as column master key, column encryption key, sequence, and security policy, which are not supported by SQL Server 2008 R2 (10.50). This topic describes how dbForge Studio for SQL Server treats such incompatibilities.
If the source schema contains objects that are not supported on the target Microsoft SQL Server server, they are not displayed in the Schema Comparison document and are not affected by synchronization.
If the target schema contains objects that are not supported on the source Microsoft SQL Server 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 SQL Server 2008 R2 (10.50) and SQL Server 2016 (13.0), 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 the target object DDL.