Bulk Conversion
On this page
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.
About this Task
The query converter uses AI technology which may not be able to convert long or complex queries, triggers, packages, or stored procedures. Some queries may not be converted correctly while others may not be converted at all. For more information, see AI and Data Usage Information.
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, packages, 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:
IconDescriptionStatic 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.
Steps
Select your conversions
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.
Convert queries
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
.
Next Steps
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.