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
An IP address, Port, User Name and Password is usually required as obligatory information to set up
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
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
the main window you can add as many connections as you wish. All of them will remain in this list
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
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
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.
feature, you can arrange your transferring process as a scheduled task and run it at any time you
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
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.
"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
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
all of your settings. With this feature, you can arrange your conversion process to be run as a
task and run any time you need it to run.