DBConvert Studio. Copy data between the most popular databases.

This video shows a simple step-by-step scenario for copying data between different databases.

DBConvert Studio is intended for DBAs who need complex migrations and synchronization between the most popular DBMS.

DBConvert Studio supports the most popular on-premises databases and Database Cloud platforms. It becomes a brilliant all-in-one solution, combining robust database migration engines with a user-friendly interface.

DBConvert Studio supports more than ten of the most popular on-premises databases, including
SQL Server,
MySQL,
PostgreSQL,
Oracle,
Interbase,
IBM DB2,
and more.

For large amounts of storage, it might be wise to consider migrating your databases to one of the following Cloud platforms using DBConvert Studio:
Amazon RDS / Aurora,
Microsoft Azure SQL,
Google Cloud SQL,
and Heroku Postgres.

Read more about DBConvert Studio at https://dbconvert.com/dbconvert-studio

---

Closed Caption:

The simplest scenario is to Copy Data from the source database to the target database.
Let's add a new connection to the database. Click the "+" button.
A pop-up dialog box contains database configuration options. Let's select the MySQL database type here.
Click the "Test Connection" button to try to connect to the server with the specified parameters.
Click the "Save" button to make the connection available for use as a source or destination node.
You have a new MySQL connection in your database connections list.
Click "+" button to add one more DB Connection.
Select MS SQL Server and configure the parameters for connecting to the database. Click "Save" button.
Click the "Connect" buttons to establish actual connections to the database nodes that will participate in the migration process.
Click the "arrow" next to the Connect link to expand the list of databases/ schemas from the dropdown list.
Click the "orange db icon" to add this database as a source.
Click the arrow next to another database connection to expand the list of available databases/ schemas.
Now click the "Add New Database" button to create a new one for the target database.
Select the newly created database as the target by clicking the "blue db icon".
Now expand the list of tables in the source database by clicking the arrow button and select only the tables you want to copy from the list.
Click "customization" in the lower right corner to configure additional migration options. A pop-up dialog prompts you to name the job to save all settings.
A new tab opens automatically. Various configuration options are offered here.
Check the boxes next to the items to select/ deselect individual tables/ fields to include or exclude from migration.
Find different options on the right to customize database/ tables / indexes options.
Click the "commit" button to start the actual conversion process. A pop-up window shows the current progress of operations.
Click the "Process History" link to view the completed work logs.