SQL Database Sync

For databases with a huge amount of records, slow data retrieval can be a common issue; however, Automatic Archiving may complicate querying older records. In such cases, the SQL Database Sync feature allows you to store data in the SQL database, enabling efficient querying, filtering, and analysis.

Setting Up SQL Database Sync

On the Listing Page, click Tools and select SQL Database Sync under Sync & Notify.

Select the DB Type, enter the required details, and click Save SQL sync config.

Note:

1. The DB name, User, and Password must correspond to your SQL database, not your Ragic account information.

2. The table name cannot contain spaces and special characters(e.g., @, #, $, .,- ).

After saving, the Sync now button will appear. Click it to synchronize your data with the SQL database.

When adding or modifying records, click Sync now again to update the changes in the SQL database.

SQL Database Versions

Refer to the table below for supported database types and versions: