DBConvert Studio
Convert and sync across all your databases: servers, cloud and files.
Rather not run it yourself?
Let us do the migration →Servers
Cloud
Files
Good to know
- Convert can also write a MySQL or PostgreSQL dump file.
- Excel works with Convert only, not Sync: as a source, or as a new workbook.
- DB2 pairs with SQL Server, MySQL and PostgreSQL.
Watch a SQL Server to PostgreSQL migration
One take in real time: the source, the destination, the plan, the run, and every row checked against the source.
How it works
1
Setup
- Pick Convert or Sync.
- Choose the source and the destination. A new connection starts with a card for each database type.
- A connection is saved once and reused by every job.
Verify the copy New
A run can finish without errors and still leave changed data: some servers store a value they cannot hold in another form. Verify checks the destination after the run, on three levels:
- Schema - every table and column is there, with the planned type.
- Totals - row counts, sums, earliest and latest dates and text length match on both sides.
- Rows - every row matches the one that was copied. The window shows which rows and columns differ.
Tick Verify after the run on Execution.
How Verify worksMuch faster on large databases
Conversion and synchronization now take a fraction of the time.
- Large tables are split across Worker threads, set on Execution.
- Indexes are built after the data is loaded.
Time for a table of 10 million rows
Convert
| Direction | Time |
|---|---|
| MySQL to PostgreSQL | 15 s |
| PostgreSQL to SQL Server | 22 s |
| SQL Server to PostgreSQL | 22.5 s |
| Oracle to MySQL | 32 s |
| MySQL to Oracle | 35 s |
| Firebird to SQL Server | 37 s |
Sync, nothing changed
| Direction | Time |
|---|---|
| PostgreSQL to MySQL | 23 s |
| MySQL to PostgreSQL | 26 s |
Measured on our test stand, single runs. Convert at 16 worker threads; MySQL to PostgreSQL and Firebird to SQL Server at 4.
Run it again
- Saved jobs - a job saves itself as you work. Jobs in the left rail lists them; open one and run it again.
- Schedule… on Execution - daily, weekly or monthly. It runs with the app closed, as long as you are logged in to Windows.
- Command line -
--run-jobwith the saved job's name, for your own scripts.


