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.
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.
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:
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.
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.
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
NOTE: If you don’t need to convert the whole database from the Master Node, you can select only the needed table(s).
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.
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.
All created Jobs are displayed at the bottom of the Main window.
You can filter jobs by types pressing appropriate tab at the top of jobs view.
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.
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
When migration is finished you can examine the operation log details and any reported errors.
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.