blog posts

Conversion of MySQL, Oracle databases to each other

This article discusses converting MySQL, SQL Server, Oracle, Microsoft Access, and SQL Dump databases to each other using Database Full Converter and Database Publishing Wizard software.

The list of this article (by clicking on any title you will be transferred to that part) hidden
Convert Microsoft Access database to Microsoft SQL Server database
Convert MySql database to SQL Server database
Convert Oracle database to SQL Server database
Convert Microsoft SQL Server database to Access database
Convert MySql database to Access database
Convert Oracle database to Access database
Convert Access database to MySQL database
Convert SQL Server database to MySQL database
Convert Oracle database to MySQL database
Convert Access database to Oracle database
Convert SQL Server database to Oracle database
Create MSSQL Dump using Database Publishing Wizard software

There are various softwares for converting different databases to each other, among the most popular ones, we can mention: Database Full Converter and Database Publishing Wizard. In the following, we will discuss how to convert different databases to each other, which is used in the implementation of projects in Linux and Windows hosting services.

Convert database Access Microsoft to database Microsoft SQL Server

Step 1: First, we double-click on the Full Convert software to open the window in Figure 1. Then click on Create new conversion option.

Second step: In this section, you must select the current database, which is Access, in the Available source databases section. On the right side of the current page, under the Filename section, enter the complete path where the Access database is located, or click on the “…” sign to find its path and click on the Next option.

Step 3: Select the SQL Server database on the destination database selection page. On the right side of the current page, if SQL Server is running locally on your system, you should just find your database name next to Database.

Note: If your database version is older than SQL 6.5, select the Compatible option.

If your server database is located in a network, in addition to the above factors, you must also enter the name or IP of the server in the Server field.

Note: For the SQL Server Express version, it is necessary to enter the Server field as SERVERNAMEINSTANCE (myserversqlexpress).

Fourth step: now it is necessary to select the necessary tables to convert to SQL Server in the Convert section and put the ones you don’t intend to convert in the Do not convert section. Then click on the Next option.

Fifth step: Ready to convert your data page! In fact, the final page is your database conversion. By default, the “I want to convert immediately” option is selected, which is actually the right option for our conversion. Then click on the Convert button.

Convert membership databases

Note: The option “I will first explore my target database and run the conversion myself” actually only allows us to find the destination database.

Step 6: After completing the above steps, a confirmation window will appear, and in order not to be asked the question in the box, you can select the Always show this dialog option and then click on the Continue option. By clicking on continue, the process of converting the source database to the destination database starts.

Seventh step: In the Converting your database window, you can stop the conversion process whenever you think necessary, for this purpose, just click on the Cancel option. In this window, you can see the speed of data transfer from the source database to the destination database and the number of processed records of each table.

Step 8: After the conversion, you will be able to see the summary of the conversion and the errors and warnings, which you can save separately if needed. In the SQL Log tab, you can view the SQL script and save it if you use and execute it in another database (especially in different versions).

Step 9: On the final page called Navigating structure tree, you will be able to see the destination database. At the same time, you can apply various modifications, such as changing the column name or structure, or changing its type, deleting old columns, extracting a part of a table in a new table, etc.

Note: Due to the repetition of the first, second, sixth, seventh, eighth, and ninth steps in all conversions of this article, they have been avoided to be mentioned again and only the mentioned steps have been mentioned.

Convert MySql database to SQL Server database

First of all, before converting, consider what MySQL is and do the first step.

Take the first step.

Step 2: In the source database selection window, click on MySQL. In the right part of the page, in the Server field, enter the name or IP of the remote server and the port required for connection, and the username and password, and select the name of the database from the Database list. For the local system, just click on the database name and select its name from the list. Then click on the Next option.

Step 3: In the destination database selection window, click on the SQL Server option. In the right part of the page, enter the name or IP of the remote server in the Server field and select the name of the database from the Database list. For the local system, just click on the database name and select its name from the list. If your database version is older than SQL 6.5, check Compatible.

Note: For the SQL Server Express version, it is necessary to enter the Server field as SERVERNAMEINSTANCE (myserversqlexpress). Then click on the Next option (according to Figure 3).

Fifth step: now it is necessary to select the necessary tables to convert to SQL Server in the Convert section and put the ones you don’t intend to convert in the Do not convert section. Then click on the Next option.

Do steps 6 to 9.

Convert Oracle database to SQL Server database

At first, before converting, by considering what you know about SQL Server . take the first step

Step 2: On the source database selection page, click on the Oracle database. Regarding the local system, if the Oracle client interface (OCI) is installed on your local system, select the name of your Oracle database service (SID) in the Service field. Enter the username and password in the Username and Password fields respectively. Then select the type of authentication system in the Auth.Mode field. If OCI is not installed on your system or the destination database is far away, you can select the Direct TCP/IP option. By selecting the Direct option TCP/IP, you must also enter the name of the Oracle database service and the username and password. You must also specify the authentication system. In the server field, enter the name or IP of the source server and the Oracle port on it (default 1521) and click on the Next option.

Step 3: Select the SQL Server database in the destination database selection window. In the right part of the page and in the Server field, enter the name or IP of the remote server and select the name of the database from the Database list. In Authentication, if you select the Mixed option, you must enter the username and password of the database user. For local system, just click on the database name and select its name from the list. If your database version is older than SQL 6.5, select the Compatible option. Keep in mind that for SQL Express, it is necessary to enter the Server field as SERVERNAMEINSTANCE (myserversqlexpress). Then click on the Next option (according to Figure 3).

Fourth step: now it is necessary to select the necessary tables to convert to SQL Server in the Convert section and put the ones you don’t intend to convert in the Do not convert section. Then click on the Next option.

Do steps 6 to 9.

databases MySQL Convert

Convert Microsoft SQL Server database to Access database

Before doing anything, we recommend that you first familiarize yourself with the concepts of Access software and then take the first step.

Step 2: In the source database selection window, click on the SQL Server option. In the right part of the page, enter the name or IP of the remote server in the Server field and select the name of the database from the Database list. For local system, just click on the database name and select its name from the Database list. If your database version is older than SQL 6.5, select the Compatible option. Keep in mind that for SQL Express , it is necessary to enter the Server field as SERVERNAMEINSTANCE (myserversqlexpress). Then click on the Next option.

Step three: In the window of selecting the destination database, click on the Access option. In the right part of the current page, enter the path of the Access database or click on the “…” symbol to find the Access file you want. Then click on the Next option.

Step 4: Now you need to select the necessary tables to convert to Access in the Convert section and put the ones you don’t intend to convert in the Do not convert section. Then click on the Next option.

Do the fifth to ninth steps.

Convert MySql database to Access databases

Take the first step.

Second step: In the source database selection window, click on the MySQL option. On the right side of the current page, enter the name or IP of the remote server in the Server field and select the name of the databases from the Databases list. For local system, just click on the database name and select its name from the Database list. Then, enter the username and password of the database user in the Username and Password fields, respectively, and click Next (according to Figure 11).

Step three: In the window of selecting the destination database, click on the Access option. In the right part of the current page, enter the Access database path or click “…” to find the destination Access file. Then click on the Next option (according to Figure 14).

Step 4: Now you need to select the necessary tables to convert to Access in the Convert section and put the ones you don’t intend to convert in the Do not convert section. Then click on the Next option.

Do the fifth to ninth steps.

Convert Oracle databases to Access database

Take the first step.

Second step: In the source databases selection window, click on the Oracle option. Click on Oracle Databases. Regarding the local system, if the Oracle client interface (OCI) is installed on your local system, select the name of your Oracle databases service (SID) in the Service field. Enter the username and password in the Username and Password fields respectively. Then select the type of authentication system in the Auth.Mode field. If OCI is not installed on your system or the destination databases is far away, you can select the Direct TCP/IP option. By selecting the Direct option TCP/IP, you must also enter the name of the Oracle databases service and the username and password. You must also specify the authentication system. In the server field, enter the name or IP of the source server and the Oracle port on it (default 1521). and click on the Next option (according to Figure 12).

Step three: In the window of selecting the destination databases, click on the Access option. In the right part of the current page, enter the path of the Access database or click on “…” to find the Access file you want. Then click on the Next option (according to Figure 14).

Step 4: Now you need to select the necessary tables to convert to Access in the Convert section and put the ones you don’t intend to convert in the Do not convert section. Then click on the Next option.

Do the fifth to ninth steps.

Convert Access databases to MySQL database

Take the first step.

Second step: In the source databases selection window, click on the Access option. In the right part of the current page, enter the path of the Access databases or click on … to find the desired Access file. Then click on the Next option (according to Figure 2).

Step 3: In the destination databases selection window, click on the MySQL option. On the right side of the current page, enter the name or IP of the remote server in the Server field and select the database name from the Databases list. For local system, just click on the database name and select its name from the list. Then click on the Databases field and find the databases you want. Enter the username and password of the database user in the Username and Password fields, respectively, and click Next