DBConvert Studio - Database Migration/ Sync.

DBConvert Studio 
 Version: 1.0.8        Released: Sept. 2, 2016

Supported databases:

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

DBConvert Studio is a Cross Database Migration and Synchronization software which serves to convert database structures and its' data between various formats. Different sync options keep data fresh for both source and destination database nodes.

DBConvert Studio combines mature, stable, time-proof DBConvert and DBSync Cores with improved up-to-date UX design.

Source and Target database connections may be configured for any local or remote MS Windows/ Linux/ OS X or BSD based Database servers.

The application enables you to migrate data in different ways. You can choose from the following scenarios:

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

By default all Source DB elements preselected for transferring to a destination database node. Some of DB elements like tables, fields, primary keys, indexes, views and schemas can be copied individually as well.

You can fully customize the migration process.

  • The data types can be changed with mapping feature;
  • All databases objects can be renamed;
  • Filters can be applied to retrieve subset data from Source;
  • Flexible Built-in Scheduler can automate tasks transfer to run them repeatedly;
  • Preliminary error checking helps to correct the settings for a target database before copying if they are configured improperly;

and many more features for effective replication and migration.

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

OS x86

OS x64

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 the 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 dbs.  IP address, Port, User Name and Password id usually required as obligatory information to set up database connection. Pictures below show MySQL as a Source node and MS SQL as a Destination for our tutorial.

Click ‘Test connection’ button. The application tries to connect to your Server with specified parameters. A confirmation message appears in case connection is established successfully:

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

2. Migration Models. Source and Target Database Setup.

Choose the Migration model. Let’s pick Master to Slave model - the most simple scenario where data flows from one source to one destination.

Click 'Connect' to establish an actual connection to database nodes which will be involved into migration process

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

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

Click 'Customize' button to proceed to the next step.

3. Migration Tuning.

In the next step you can adjust settings for chosen Source and Target nodes in details.

Click 'Commit' button to start actual conversion/ sync process.

4. Actual Process of data transfer.

Here you will see 2 progress-bars showing the whole conversion progress and the current operation progress.

When migration is finished you can see the operation log details and possibly happened errors.

NOTE: When you press 'Commit' button, a Job of the current process automatically creates and all the settings are saved there automatically. Then, the conversion process can be arranged as a scheduled task and can be run at any time you need.