Docs Menu
Docs Home
/
Relational Migrator
/ /

Bulk Conversion

On this page

  • About this Task
  • Steps
  • Next Steps
  • Learn More

Bulk query conversion allows you to convert many queries from a single UI action, avoiding the need to convert each query individually. You can select and convert one or more queries, stored procedures, triggers, and views in bulk by enabling the multi-select toggle.

Bulk conversions create a job that queues and executes each query conversion in batches. You can view the status of an in-progress bulk conversion or for individual queries in the Query Converter pane.

  • The query converter uses AI technology which may not be able to convert long or complex queries, triggers, or stored procedures. Some queries may not be converted correctly while others may not be converted at all.

  • The query converter uses the relational schema, the MongoDB schema, and the mapping rules in your current project to determine how the queries should be converted. Conversions may fail or be incorrect if the queries reference tables that are not in your relational schema or if they are not mapped to MongoDB collections.

  • Converted queries, triggers, views, and stored procedures are saved in your project and persist through project import and exports.

  • SQL queries are limited to 40,000 text characters.

  • Always review and test the code generated by query converter before deploying it in a production environment.

  • You can view the status of your conversions in the left-hand Query Converter pane. Each conversion has an icon indicating the status of the conversion. If an object does not have an icon next to it, it was not queued for bulk conversion:

    Icon
    Description
    Static circle
    The conversion is pending.
    Spinner
    The conversion is now being executed.
    Green check mark
    The conversion was successful.
    Red exclamation mark
    The conversion failed on last attempt.
1

From the Code Generation tab, click the Query Converter pane.

2

Click the Enable multi-selection toggle to show the query selection pane.

3
  • To include or exclude a query from your bulk conversion job, click the icon next to the field name.

  • To include or exclude entire categories from your download, click next to the category name.

  • To include or exclude queries by their current status, use the Filter to select a status.

4

Click the Convert button. Selected queries are queued for conversion and execute in batches. Total progress of the conversion displays at the bottom-left of the page.

  • Individual query conversion status are displayed next to the query name.

  • The converted MongoDB syntax code can be viewed in the Converted MongoDB Query pane.

  • If the query converter has errors, you can view the details in the Converted MongoDB Query pane.

Tip

To stop a bulk conversion, click the red Terminate button in the lower-left corner of the screen and click the red Terminate button on the pop-up modal. Once a bulk job cancels, the bulk conversion status updates to Bulk convert job terminated.

5

Provide feedback on converted queries to help improve future query conversions. To provide feedback, click the or icon on the bottom right corner of the converted query panel. Then, you can provide feedback details and click Submit.

After the queries have been converted, review them for correctness before incorporating them into production code. You can use the Test Queries feature to help with validation.

Back

Convert Views