Access Database conversion to mysql database

I. Software introduction DB2MYSQL is a software that can automatically convert ACCESS database files into corresponding SQL code. It can be widely used in the conversion of ACCESS databases to MYSQL or other types of SQL databases. DB2MYSQL allows you to operate databases visually. The conversion interface is simple and clear, allowing you to easily convert an ACCESS database to MYSQL data.

I. Software introduction DB2MYSQL is a software that can automatically convert ACCESS database files into corresponding SQL code. It can be widely used in the conversion of ACCESS databases to MYSQL or other types of SQL databases. DB2MYSQL allows you to operate databases visually. The conversion interface is simple and clear, allowing you to easily convert an ACCESS database to MYSQL data.

I. Software Introduction

DB2MYSQL is a software that can automatically convert ACCESS database files into corresponding SQL code. It can be widely used in the conversion of ACCESS databases to MYSQL or other types of SQL databases.

DB2MYSQL allows you to operate databases visually. The conversion interface is simple and clear, allowing you to easily convert an ACCESS database to a MYSQL database. If you want to convert the SQL server database to MYSQL, you can also use this software. The specific operation is to first use SQL server's "import and export data" to export SQL SERVER data to the ACCESS file, then export the ACCESS file as a MYSQL statement.

After the conversion function is run, the system generates two outputs: one is to output the converted SQL statement on the screen interface, and the other is to automatically generate a suffix under the output directory. SQL text file, which records the generated SQL statements.

To use this program, you must have some background knowledge about the database structure principle and SQL language.

Ii. Operation overview

This software is an English interface, pure green software. However, you must install Microsoft MDAC (Microsoft Data Access Components) before using it. First, extract all the files to the desired folder. Run the DB2MYSQL. EXE file.

After running the software, select the database, table, and field to be used in the Start interface. Specific operations:

1. Open the desired ACESS database. The tables in the database are listed in the list box of data tables. Click data table to list all fields in the current data table.

2. Click the expected table to select the table and field.

3. Confirm the data table and click the [Start] button. The SQL statement can be automatically generated.

4. Run PHPMYSQL. first create a table that is exactly the same as the ACCESS table, and then import the automatically generated SQL statement to convert ACCESS data to MYSQL data.

The converted SQL statement can be executed not only in MYSQL, but also in Microsoft SQL Server and ACCESS.