DBConvert Studio - Database Migration and Synchronization.

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 list.

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.

Jobs.

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.

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;

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.

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.