SQL Export and Validate







Results

This tool provides five main functions:

1. Export: Downloads selected rows (e1 to e2) from the batch table as SQL INSERT statements.

2. Validate: Checks data integrity of specified rows, verifying existence and required fields (batch, sfobj, data, debug, create_time).

3. Automate: Performs batch exports with automatic chunking. Splits large ranges into smaller batches (default 100 rows) for efficient processing.

4. Backup: Similar to export but saves SQL files to the '/export/' directory on the server instead of downloading.

5. Automate Backup: Performs automated cleanup and backup of older records. Keeps a specified number of newest records (default 500) and processes older records in chunks (default 10), backing them up before deletion.