Research on the migration of Access database

Background: Because the business information system software was designed for Access database architecture, after a period of operation management, it is found that Access database is increasingly unable to support the operation management of business systems. Therefore, consider replacing the database.

Discard the Access database and prefer the MySQL database. Although the size of MySQL is small, but the function is sufficient, storage speed, basic can meet the requirements of upgrade and transformation. What you typically do when migrating from an Access database to a MySQL database.

(1) Migrating Access tables to MySQL database

Create the same table in the MySQL database against the Access database tables. The Access data table contents are then migrated to the MySQL database. When you migrate table content, you can save the contents of the Access table to a text file, and then import the text file into the MySQL database. As shown in Fig. 1, Figure 2

Figure 1

Figure 2

You can also use a Access2mysql tool to import, can be: http://download.csdn.net/detail/lejuo/7923691, the specific operation can refer to: http://jingyan.baidu.com/ Article/ff42efa964dab7c19f220210.html

(2) Rebuilding the database access code of software system

The Access database accesses a driver that is inconsistent with MySQL and requires a careful review of the code in the software system and the replacement of the MySQL database access code.

Complete the above two steps, basically to solve the problem of Access database migration, then you can carefully test the software system, to minimize the errors caused by the database migration.

In addition, the Access migration database has other options--do not move the database access code of the software system, only the database content, the steps are as follows:

(1) If the above method is general, first build the same table as access in MySQL database, and migrate the content as well.

(2) Delete the tables in the Access database and create the source table links to the MySQL datasheet through the external Data feature of access. As shown in the following:

Figure 3

Figure 4

Figure 5

This way, in an Access database, you can see a table link to the MySQL database you just created, and then you can do some additions and deletions as you do with access tables.

Figure 6

----------------------

Additional information, if the MySQL data table migrated to the MSSQL database, there is a netizen sharing the case

http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=35184

Research on the migration of Access database