Access database migration

Because the Access database architecture was previously designed for the business information system software, after a period of operation management, it is found that Access databases are increasingly unable to support the operation management of business systems. Therefore, consider changing the database. Abandon Access database, MySQL database is preferred. Although MySQL is small in size, its functions are sufficient and the storage speed is fast, which can basically meet the needs of upgrading and modifying

Because the Access database architecture was previously designed for the business information system software, after a period of operation management, it is found that Access databases are increasingly unable to support the operation management of business systems. Therefore, consider changing the database. Abandon Access database, MySQL database is preferred. Although MySQL is small in size, its functions are sufficient and the storage speed is fast, which can basically meet the needs of upgrading and modifying

Because the Access database architecture was previously designed for business information system software, after a period of operation management, it was found that Access databases are increasingly unable to support the operation and management of business systems. Therefore, consider changing the database.

Abandon Access database, MySQL database is preferred. Although MySQL is small in size, its functions are sufficient and the storage speed is fast, which can basically meet the upgrade and transformation requirements. What do I do to migrate data from an Access database to a MySQL database.

(1) migrate the Access Table to the MySQL database

Create the same table in the MySQL database against the Access database table. Then, migrate the Access data table content to the MySQL database. When migrating table content, you can first store the Access Table content to a text file and then import the text file to the MySQL database. As shown in 1.

　　

　　

(2) Rebuilding the database access code of the Software System

The Access Database Access driver is inconsistent with that of MySQL. In the software system, you must carefully review the code and change it to the MySQL database Access code.

After completing the above two steps, the Access database migration is basically solved. Next, you can carefully test the software system to minimize errors caused by database migration.

In addition, there are other ways to migrate the database through Access-The database Access code of the software system can only migrate the database content. The steps are as follows:

(1) In general, create tables with the same Access in the MySQL database and migrate the contents together.

(2) Delete the tables in the Access database, and create a link to the source table of the MySQL DATA table through the "external data" function of Access. As shown in:

　　

　　

　　

In this way, in the Access database, you can see a link to the table you just created to the MySQL database. After that, you can perform addition, deletion, modification, and query operations like the Access Table operation.