PROJECT OPTIONS

Database

Table prefix allows you to specify a text that Full Convert prepends to the target table name.

Name casing tunes table and column name casing to your expectations:

  • Default - use the default for specific target database. Some have uppercase, some have lowercase
  • Uppercase - force uppercase everywhere
  • Lowercase - force lowercase everywhere
  • Unchanged - preserve mixed-case names
  • Camel case - if you have snake case names, they will be converted to camel case
  • Snake case - if you have camel case names, they will be converted to snake case

Source WHERE filter allows you to copy only part of the data. As this is a filter applied to all tables in the project, you should only specify the SQL condition here if it is indeed present in all tables. Otherwise use the per-table options.

Target WHERE filter is applied when fetching data from the target table, which happens in comparison and replication operations.

Previous
Performance

If this was useful,
our newsletter will be too.

Get monthly insights on data engineering, AI, and building critical infrastructure - direct from the Spectral Core team and CEO Damir Bulic.