Restrictions on the creation of DDL are as follows:
-
Oracle does not return DESCending index fields properly; some generated system names are returned, so the generated CREATE INDEX will fail.
-
Sybase and MS SQL Server currently do NOT determine if an index column is ASCending or DESCending, so all the CREATE INDEX statements generated will assume ASCending.
-
The Generate DDL command does not generate a CREATE TABLE statement that maintains column definitions that specify case sensitivity.
Case sensitivity can be set at the column level so if you have case-sensitive data and used the Generate DDL command to create the target table, replication might fail. For example, case sensitive data may include values such as "Ab" and "aB" and "ab". If you do not properly defined the target column, all values will be translated to "AB" or "ab". This is only a problem if the target column is part of the primary key or unique index.