Step-by-step DBConvert Studio tutorial for cross-database conversion
1. Preparation
- Backup: Export or snapshot source and target databases.
- Credentials: Note host, port, database name, username, and password for both databases.
- Permissions: Ensure user accounts have read on source and write on target.
- Network: Confirm connectivity (firewall, VPN) and that target accepts remote connections.
2. Install and launch
- Download and install DBConvert Studio for your OS.
- Open the application and choose “New Project” (or “New Conversion”).
3. Configure source and target
- Source: Select DBMS type (e.g., MySQL, PostgreSQL, SQL Server), enter connection details, test connection.
- Target: Select target DBMS type, enter connection details, test connection.
- Encryption/SSH: Configure if needed (SSH tunnel, SSL).
4. Select conversion mode
- Choose between One-time Migration or Synchronization (bi-directional, source→target).
- For incremental updates, select sync with schedule if available.
5. Mapping and options
- Open mapping screen to:
- Select databases/schemas and tables to convert.
- Map source tables/columns to target equivalents (rename if needed).
- Adjust data type mappings if automatic choices are unsuitable.
- Set options:
- Preserve keys/indexes/constraints.
- Handle identity/auto-increment columns.
- Enable foreign key recreation order.
- Choose how to handle conflicts (overwrite, skip, append).
6. Data transformation (optional)
- Apply column transformations, expressions, or filters to include/exclude rows.
- Use value mappings for enum-like conversions.
7. Preview and test
- Run a schema-only conversion to create target schema first.
- Convert a small subset of rows to validate mappings and transformations.
- Verify data integrity, types, indexes, and referential constraints on target.
8. Run full conversion
- Start the full migration or synchronization.
- Monitor progress and logs for errors or warnings.
- If errors occur, review logs, fix mapping or permissions, then resume.
9. Post-conversion checks
- Validate row counts and sample data across key tables.
- Check indexes, constraints, triggers, and stored procedures if migrated.
- Run application tests against the target database.
10. Schedule and maintain (if sync)
- Configure recurring synchronization schedule if continuous sync is required.
- Monitor periodic runs and review change logs.
Quick checklist (copyable)
- Backup source & target
- Confirm credentials & permissions
- Test connections
- Map schemas/tables/columns
- Preview schema & sample data
- Run full migration
- Verify data integrity
- Configure schedule (if needed)
If you want, I can produce a ready-to-run mapping template or a sample set of transformation expressions for a specific source/target pair (e.g., MySQL → PostgreSQL).
Leave a Reply