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.
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.
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.
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.
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.
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.
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.
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.
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!
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.
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.
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.
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.
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.
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.
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!
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.