How to Transfer Database from MySQL Server to Other Database Server

Table of Content

Software Working Process
Activation Guide
Installation & Uninstallation
User Interface
Software Working Video

Software Working Process

Migrate MySQL Database to MS Access Database

Steps to perform the migration of MySQL database to MS Access database.

STEP 1

Download and Install the Aryson MySQL Database Migration Tool.

STEP 2

Launch the tool as Administrator.

STEP 3

Enter MySQL login credentials. (Server, Port No., Username, Password) Tap the Connect button.

STEP 4

After the connection to the MySQL database, Select the Database that you want to migrate. Also, Transfer mode either Database or Table and tap the Next button.

STEP 5

In the next step, click on the dropdown symbol and choose MS Access.

STEP 6

Now, opt for any one option.

Create New MS Access (.mdb./.accdb) file:- Using this option, you can create a new .accdb or .mdb file to migrate the MySQL database.
Use Existing MS Access (.mdb./.accdb) file:- It helps to use the existing MS Access file .accdb or .mdb file to save the MySQL database.

STEP 6.1

To create New MS Access (.mdb./.accdb) file:- Choose the MS Access version and File format & enter MS Access file name . Additionally, click the Destination path and choose the saving location.

STEP 6.2

For Existing MS Access (.mdb./.accdb) file:- Click on the Browse file button to select the ACCDB/MDB file of MS Access from your local machine.

Note: You can also select the password-protected MS Access .mdb/.accdb file

STEP 7

After making the successful connection, press the Next button.

STEP 8

Here you can view the migration details- Source database, source database name, Source table, Destination database, Destination database name, target table, description, and status. Also, Click the Start button to initiate the migration.

STEP 9

The migration process has started now. Tap the Stop button to close the migration process.

STEP 10

Completed the migration process of MySQL to MS Access database.

STEP 11

Tap the Preview button to view the tables.

STEP 12

Now. pick Source or Destination either MySQL or MS Access. After that, Choose the database and table that you need to inspect and tap the Show tables button.

STEP 13

At last, click on the Exit button to close the Aryson MySQL Database Migration Tool.

MYSQL to Oracle Database

MYSQL to Oracle Script File

Migrate from MySQL to Oracle Database

To migrate from MySQL to Oracle follow the steps.

STEP 1

Install and launch the MySQL Database Migration Tool.

STEP 2

Now, enter the login details of MySQL Database and click the Connect button.

STEP 3

Here, in the next panel, select the Database which you need to migrate. Also, opt for the transfer mode as Database or Table and click Next.

Note: If you choose the Table option, then select the table(s) from the below-displayed tables.

STEP 4

After that, Select the Oracle option from the displayed drop-down.

STEP 5

Enter the login credentials of the Oracle database and click the Connect button.

Note: To migrate MySQL Table to Oracle Remotely, Enter the IP address of Destination in the hostname field.

STEP 6

After the successful connection with Oracle, tap the Next button.

STEP 7

Now, the software will fetch the migration details and display the details. After that, click on the Start button.

STEP 8

The migration process will start. You can tap the Stop button to end the process.

STEP 9

Now, the process has been completed.

STEP 10

Click on the Preview button to display the tables.

STEP 11

Now. select the Source or Destination either MySQL or Oracle. Now, Choose the database and table that you want to view and tap the Show tables button.

STEP 12

Finally, hit the Exit button to close the software.

Migrate MySQL Database to Oracle SQL Script

Practice the below-mentioned steps to migrate MySQL database to Oracle SQL Script.

STEP 1

Run MySQL Database Migration Tool as Administrator.

STEP 2

Click Connect by entering the MySQL Login credentials.

STEP 3

Pick the Database which you want to migrate.

STEP 4

Opt for the Transfer Mode. Either Database or Table.

STEP 5

After that, tap Next to move the process further.

STEP 6

Select Oracle SQL Script from the drop-down.

STEP 7

Now, click the Destination Path button and select the location to save the script file. Additionally, tap Open.

STEP 8

Again, click Next to proceed with the process.

STEP 9

In this panel, you can inspect the migration details. Click the Start button.

STEP 10

Successfully migrate the MySQL Database to Oracle SQL Script.

MySQL to MS SQL Server
MySQL to MS SQL Server SQL Script File

Import MySQL database into MS SQL Server

Follow the steps to import MySQL database into another MS SQL Server.

STEP 1

Install and Run the MySQL Database Migration Tool.

STEP 2

Enter the credentials of MySQL and click on the Connect button.

STEP 3

After that, select the Database and choose the transfer mode as Database or Table. Also, click Next.

STEP 4

Choose the MS SQL Server from the drop-down.

STEP 5

Select the Authentication mode as Server Authentication or Windows Authentication. Enter the login credentials of MS SQL Server and click on the Connect button.

Note: To migrate MySQL Table to MS SQL Server Remotely, Enter the IP address of Destination in the hostname field.

STEP 6

After the successful connection, tap the Next button for further process.

STEP 7

Now, the software will fetch the migration process and display the details of the migration. Here, tap the Start button to initiate the process.

STEP 8

The process has started now. (In case, to end the process, press the Stop button)

STEP 9

Finally, completed the process to import MySQL database to another MS SQL Server database.

STEP 10

Now, the software allows a preview of the tables. Click Preview.

STEP 11

Here, choose the Source or Destination (MySQL or MS SQL Server). Now, Choose the database and table that you want to view and click on the Show tables button.

Export MySQL Database to MS SQL Server SQL Script

Step-by-step procedures to export MySQL database to MS SQL Server SQL Script.

STEP 1

Run the MySQL Database Migration Tool.

STEP 2

Enter your MySQL login credentials and tap on the Connect button.

STEP 3

Choose the Database which you need to export.

STEP 4

Select the Mode of Transfer. (Database or Table)

STEP 5

Click on the Next button to move further.

STEP 6

Choose the option MS SQL Server SQL Script from the drop-down.

STEP 7

Tap the Destination path button and choose the location. Also, press the Open button.

STEP 8

Click on the Next to move the process.

STEP 9

Now, you view the Process details in the next panel. Tap the Start button to initiate the process.

STEP 10

You have successfully exported the MySQL Database to MS SQL Server SQL Script.

MySQL to MySQL Database
MySQL to MySQL Script File

Migrate MySQL Table into MySQL Database

Follow the steps to migrate MySQL table into MySQL Database.

STEP 1

Run the Aryson MySQL Database Migration Tool.

STEP 2

Click on Connect by entering the login credential of MySQL.

STEP 3

Here, select the database from which you want to migrate the tables.

STEP 4

Select the transfer mode as Table and Check the tables that you want to export.

STEP 5

After that, tap Next.

STEP 6

In the next step, Choose MySQL from the drop-down.

STEP 7

Enter the login credentials of the MySQL database and click Connect.

Note: To migrate MySQL Table to MySQL Remotely, Enter the IP address of Destination in the hostname field.

STEP 8

After the successful connection, select the Database in which you want to migrate the selected MySQL tables. Now, tap the Next button.

STEP 9

Again the software will fetch the process details and also display them. Now hit the Start button to initiate the migration process.

STEP 10

Finally, completed the process of migrating MySQL tables to MySQL Database.

STEP 11

The software also enables users to preview the tables. Click Preview.

STEP 12

Select the Source or Destination Now, Choose the database and table that you want to view, and press Show tables.

STEP 13

To close the software click on the Exit button.

Migrate MySQL Database to MySQL Script

Follow the below-listed steps to migrate MySQL database to MySQL Script.

STEP 1

Launch MySQL Database Migration Tool.

STEP 2

Tap on the Connect button by entering the MySQL Login details.

STEP 3

Select the Database that you need to migrate.

STEP 4

Choose the Transfer mode. (Database or Table).

STEP 5

Hit on the Next button to move the process further.

STEP 6

Select MySQL Script from the drop-down.

STEP 7

Click the Destination button and select the saving location. Additionally, tap Open.

STEP 8

After that, click on the Next to move the process.

STEP 9

Here, the software will display process details. Click the Start button.

STEP 10

Successfully migrate the MySQL Database to MySQL Script.

Export a Table from MySQL to CSV

Detailed procedures to export tables from MySQL to CSV file formats.

STEP 1

Launch Aryson MySQL Database Migration Tool.

STEP 2

Sign In using the login credentials of MySQL.

STEP 3

After that, select the MySQL Database from which you need to migrate the tables.

STEP 4

In the Next step, choose the transfer node as Database or Table. If table, then you can choose the tables for migration.

STEP 5

Now, click on the Next button to proceed with the process further.

STEP 6

Select the CSV format from the drop-down.

STEP 7

Here, the software allows you to select the format from CSV or TXT. Choose CSV.

STEP 8

Click the Destination path button and select the saving path. Also, tap Open to set the destination path.

STEP 9

After that, tap on the Next button to continue the process.

STEP 10

In the last panel, you can view the details of the process and click the Start button.

STEP 11

Now, the process has started. You can end the process by tapping the Stop button.

Migrate MySQL Database to Excel Spreadsheet

Follow the below steps to migrate MySQL Database to Excel spreadsheet.

STEP 1

Install and Run Aryson MySQL Database Migration tool.

STEP 2

Click Connect by entering the credential of MySQL Database.

STEP 3

Select the Database of MySQL that you want to migrate.

STEP 4

Choose the Database or Table as transfer mode. (In Table transfer mode, check the tables)

STEP 5

Now, click on the Next button to continue the migration procedure.

STEP 6

Select the Excel option from the drop-down.

STEP 7

Here, click on the Destination path button and choose the path. Also, press the Open button to set the saving path.

STEP 8

Click Next to proceed with the process further.

STEP 9

In the next steps, you can inspect the migration details and hit the Start button.

STEP 10

Now, you can view the process started. (You can tap the Stop button to end the process)

STEP 11

Now, the process has started. You can end the process by tapping the Stop button.

Activate the Software

Online Activation

Offline Activation

Installation & Uninstallation of Software

Installation

Uninstallation

User Interface

Software Interface

Working Video

2880 Zanker Road, Suite 203, San Jose, CA - 95134, USA

A-58 , 2nd Floor A Block Sector 57, Noida, Uttar Pradesh 201301, India

Resources

Useful Link

Social & Share

Find Us on

Subscribe to our newsletter to get the latest News & Update

Software Guide to Forward or Transfer MySQL Database to Other Database Server

Software Working Process

Activate the Software

Activate the Software

Installation & Uninstallation of Software

User Interface

Working Video