DBConvert Studio - Database Migration and Synchronization.

dbconvert studio interface
DBConvert Studio
 Version: 1.8.4 Released: Nov. 23, 2020

Supported databases:

  • SQL Server
  • MySQL
  • Oracle
  • PostgreSQL
  • Access
  • FoxPro
  • SQLite
  • Firebird
  • Excel
  • IBM DB2
  • MS Azure SQL
  • Amazon RDS
  • Amazon Aurora
  • Heroku Postgres
  • Google Cloud

DBConvert Studio is a powerful cross-database migration and synchronization application which seamlessly converts database structure and data between various formats. Different sync options keep data fresh for both source and destination database nodes.

DBConvert Studio combines mature, stable, battle-tested DBConvert and DBSync Cores with an improved, modern UX design.

Source and target database connections may be configured for any local or remote MS Windows, Linux, MacOS or BSD based database servers.

This awesome application enables you to migrate data in a multitude of ways. You can choose from any of the following battle-tested scenarios:

  • Master to slave migration
  • Unidirectional synchronization
  • Bidirectional synchronization
  • Data distribution (data flows from one master database to multiple slave databases)

By default all source DB elements are preselected for transfer to a destination database node. Some of the DB elements, including tables, fields, primary keys, indexes, views and schemas can be copied individually as well.

You have full control over the migration process and can customize what you need for your particular conversion, including:

  • The data types can be changed with our mapping feature;
  • All databases objects can be renamed in the migration;
  • Filters can be applied to retrieve subseted data from the source;
  • Our flexible built-in scheduler automates tasks, allowing transfers to run repeatedly;
  • Preventative error checking helps to correct the settings for a target database before copying if they are configured improperly;

and many more features are built-in for effective replications and migrations.


DBConvert Studio is Microsoft Windows based software. It is compatible with all Windows versions including 10/ 8/ 7/ Vista/ XP/ 2000/ NT.


Requirements for DBConvert Studio


Quick Start Guide

To set up the conversion/sync follow the steps described below.

1. Add Connections

Firstly, let’s add database connections and configure them.

To add a new connection click on Connections ->Add connection, or click on the Connection button on the top right corner of the Connections window.

add connection tab

In the New Connection window select the required database type from the list of supported databases. An IP address, Port, User Name and Password is usually required as obligatory information to set up database connection. Pictures below show a source MySQL node and MS SQL destination node as this example.

MySQL connection details MS SQL connection details

Click the Test connection button. The application attempts to connect to your server with the specified parameters. A confirmation message appears once the connection is established successfully:

connection successful dialog

Click Save button to make the connection available to be used as a source or destination node. In the main window you can add as many connections as you wish. All of them will remain in this list even after closing the program.

show all connections

2. Migration Models. Source and Target Database Setup.

Choose the appropriate migration model. Let’s pick Master to Slave model - the simplest scenario where data flows from exactly one source to exactly one destination.

Choose database migration types

Click Connect to establish an actual connection to the database nodes which will be involved in the migration process

Click on the arrow next to the 'Connect' link to select the master database/schema from drop-down list.

connection link expand databases

choose master database

NOTE: If you don’t need to convert the whole database from the Master Node, you can select only the needed table(s).

selected database choose only needed tables to convert

Repeat the previous step for selecting the desired slave database.
If a destination database doesn't exist, DBConvert Studio will create a new one for you.

choose slave database

Click Add job button to create a job for the current process and save all your settings. With this feature, you can arrange your transferring process as a scheduled task and run it at any time you need.

Jobs.

All created Jobs are displayed at the bottom of the Main window.

list of all jobs

You can filter jobs by types pressing appropriate tab at the top of jobs view.

choose only sync jobs

job toolbar  Job toolbar consist of the following commands for job manipulation: "Execute", "Retune" and "Delete" accordingly.

Click Customization button to proceed to the next step. The application automatically creates a job for the current scenario.

3. Migration Tuning.

Here you can adjust different settings affecting the chosen source and destination nodes in detail.

Global Options

global options

"Load slave structure" - сheck this option if you have a task to reassign fields (i.e. field names).

"Update sync triggers" - triggers will be updated automatically on both sides (master and slave).

Check "Update sync triggers" option in the following cases:

  • if your trigger logic has changed;
  • if the time on the servers hase changed, and you need to reconfigure triggers;
  • if case of changes in a session/job. For example, a new Database is used as Destination/SlaveDestination/Slave;

custoimzation and database migration options.

Customization options are similar to the ones used to in classic DBConvert/ DBSync software.

Click Commit button to begin running the actual conversion/sync process.

4. Actual Process of data transfer.

Now you will see two progress-bars displaying the whole conversion progress as well as the progress of the current operation.

Press commit to start a job

When migration is finished you can examine the operation log details and any reported errors.

job finished

NOTE: When you press the Commit button, the application automatically creates a job for the current process and saves all of your settings. With this feature, you can arrange your conversion process to be run as a scheduled task and run any time you need it to run.