DBConvert Studio v1.6.0
DBConvert Studio is a powerful cross-database migration and synchronization application which seamlessly converts database structure and data between various formats. Different sync options keep data fresh for both source and destination database nodes.
DBConvert Studio combines mature, stable, battle-tested DBConvert and DBSync Cores with an improved, modern UX design.
Source and target database connections may be configured for any local or remote MS Windows, Linux, MacOS or BSD based database servers.
This awesome application enables you to migrate data in a multitude of ways. You can choose from any of the following battle-tested scenarios:
Master to slave migration
Data distribution (data flows from one master database to multiple slave databases)
By default all source DB elements are preselected for transfer to a destination database node. Some of the DB elements, including tables, fields, primary keys, indexes, views and schemas can be copied individually as well.
You have full control over the migration process and can customize what you need for your particular conversion, including:
The data types can be changed with our mapping feature;
All databases objects can be renamed in the migration;
Filters can be applied to retrieve subseted data from the source;
Our flexible built-in scheduler automates tasks, allowing transfers to run repeatedly;
Preventative error checking helps to correct the settings for a target database before copying if they are configured improperly;
and many more features are built-in for effective replications and migrations.
DBConvert Studio is Microsoft Windows based software. It is compatible with all Windows versions including 10/ 8/ 7/ Vista/ XP/ 2000/ NT.
- 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.
- 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.
- Migration Tuning.
Here you can adjust different settings affecting the chosen source and destination nodes in detail.
- 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.
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.