Mapping

Note: The mapping below is applied to all tables. You can override the mapping for specific table by going to the Tables screen and opening the table details screen via the Details button next to the table name.

Name casing

By default, we case the table names in the target in such a way to avoid the need to quote names when running SQL queries. If you wish to preserve the source casing, or force upper or lower case, you can change the default behavior.

  • Predefined mappings

  • Db as Schema prefix
    This setting will prefix the schema names with the database name, helping to preserve the origin of the schema when the database name is crucial for identification.
  • Db as Schema, Schema as Table prefix
    Here, the original database name becomes the schema name, and the original schema name is used as a prefix for table names, which is useful when merging multiple databases into a single schema.
  • Alias as Schema prefix
    With this option, an alias defined within the migration tool is used as a prefix for the schema names, allowing for customization and easier identification in the target system.
  • Alias as Schema, Schema as Table prefix
    This choice takes an alias for the database name and uses it as the schema name, while the original schema name is prefixed to the table names, maintaining a clear structure when the original database name should not or cannot be used directly.

Schema names

The Schema names section in database migration settings lets you define rules to translate schema names from the source to the target database using a "SOURCE=TARGET" format. The tool processes only the first rule that matches each schema and supports placeholders like {db} for the database name, {alias} for database alias, {schema} for the schema name, and {table} for the table name, which will be automatically replaced with the actual names during the migration.

Table names

Allows for the specification of renaming rules from source to target databases, using the "SOURCE=TARGET" syntax, with only the first applicable rule being executed per table. It supports placeholders such as {db} for the database name, {alias} for the database alias, {schema} for the schema name, and {table} for the table name, which are dynamically replaced with their corresponding values during the migration.

Column names

In the Column names configuration, you can establish renaming conventions for columns by creating "SOURCE=TARGET" rules. The system will apply only the first matching rule for each column, disregarding subsequent matches.

Datatype mapping

Omni Loader will always map data types in such a way that data is not lost and that the target type is as close to the source type as possible. You can opt to change the way we map the data types, by forcing the whole type to be changed or just a length of the type.

Default value mapping

Comment table column default values are automatically translated from source into the target equivalents. If you have complex default value expression we can't handle, you can define the correct target default value here and it will be applied for all columns of all tables.

What’s a Rich Text element?

The rich text element allows you to create and format headings, paragraphs, blockquotes, images, and video all in one place instead of having to add and format them individually. Just double-click and easily create content.

Static and dynamic content editing

A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel. Voila!

How to customize formatting for each rich text

Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the "When inside of" nested selector system.

lorem ipsum dolor sit amet

Phasellus diam eros, suscipit id sem nec, porttitor gravida dui. Pellentesque tempor vestibulum nisi at convallis. Aliquam augue justo, iaculis non cursus nec, pretium et velit.

  • This is some text inside of a div block.
  • This is some text inside of a div block.
  • This is some text inside of a div block.
  • This is some text inside of a div block.
lorem ipsum dolor sit amet

Phasellus diam eros, suscipit id sem nec, porttitor gravida dui. Pellentesque tempor vestibulum nisi at convallis. Aliquam augue justo, iaculis non cursus nec, pretium et velit.

lorem ipsum dolor sit amet

Phasellus diam eros, suscipit id sem nec, porttitor gravida dui. Pellentesque tempor vestibulum nisi at convallis. Aliquam augue justo, iaculis non cursus nec, pretium et velit.

lorem ipsum dolor sit amet

Phasellus diam eros, suscipit id sem nec, porttitor gravida dui. Pellentesque tempor vestibulum nisi at convallis. Aliquam augue justo, iaculis non cursus nec, pretium et velit.

What’s a Rich Text element?

The rich text element allows you to create and format headings, paragraphs, blockquotes, images, and video all in one place instead of having to add and format them individually. Just double-click and easily create content.

Static and dynamic content editing

A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel. Voila!

How to customize formatting for each rich text

Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the "When inside of" nested selector system.