PROJECT OPTIONS
Database
Project-wide settings for the target table names and for the data that is read.
Table prefix
A text that Full Convert puts in front of every target table name. For example, a prefix of exp_ turns Customers into exp_Customers.
Name casing
Tunes the table and column names in the target to your expectations.
- Default picks the casing the target database is most comfortable with, so names don't need quoting. Some databases prefer uppercase, some lowercase.
- Uppercase and Lowercase force one casing everywhere.
- Unchanged preserves the names exactly as they are in the source.
- Camel case, Pascal case, Snake case and Screaming snake rewrite the names in that style, so
OrderDetailsbecomesorderDetails,OrderDetails,order_detailsorORDER_DETAILS. Handy when the source and target follow different naming conventions.
Source WHERE filter
Copies only part of the data. The condition is applied to every table in the project, so only use it when the columns it mentions exist in all tables, such as a tenant_id or an updated_at column. For a single table, use the per-table filter in the table mapping instead. If a table has both, the two conditions are combined.
Target WHERE filter
Applied when reading the target tables, which happens in replication projects during comparison. Use it the same way to compare only part of the target data.
