Generation and validation

Use the three-step generation wizard to validate your setup and start generating.

Open it by selecting Generate in any configuration panel.

Syntho validates your source schema and destination schema before writing any data.

Validation inspects schema only. It does not write data.

Run the validations before generating

Before you start

Make sure these basics are in place:

• Your workspace is configured (included/excluded tables).
• Sensitive columns are protected with generators.
• Foreign keys are correct for your included tables.
• Your destination user has the needed permissions for write optimizations.

The 3 steps

1

Step 1. Validate source db

Detect schema drift between your workspace and the source database.

If needed, sync your workspace before you continue.

Go to Step 1. Validate source db.

2

Step 2. Validate destination db

Verify the destination can accept your included tables and columns.

Fix issues now to avoid runtime failures.

Go to Step 2. Validate destination db.

3

Step 3. Generate

Review the job summary and tune performance settings.

Start generating and monitor progress.

Go to Step 3. Generate.

Notes and common gotchas

• You must resolve issues in validations to generate.
• Destination validation focuses on included tables.
• Some destination optimizations affect all tables during writing.

Related pages

• Configure tables and generators in Table view.
• Review sensitive data coverage in Main hub.
• Manage keys and relationships in Manage foreign keys.
• Debug runs via Logs and monitoring.
• Tune bigger jobs in Large workloads.

Next: start with Step 1. Validate source db.