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.
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.
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:
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.
Connect to establish an actual connection to the database nodes which will be involved in the
Click on the
arrow next to the 'Connect' link to select the master database/schema from drop-down list.
NOTE: If you don’t need to convert the whole database from the Master Node, you can select only the needed
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.
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:
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.
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
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.