Research on the migration of Access database

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

Discard Access database, preferred MySQL database. Although MySQL is small in size, but the function is sufficient, the storage speed is fast, basically can satisfy the request of the upgrade transformation. What you typically do when migrating from an Access database to a MySQL database.

(1) Migrate access tables to the MySQL database

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

Figure 1

Figure 2

(2) Reconstruct the database access code of the software system

Access database accesses the driver and MySQL is inconsistent, in the software system requires careful review of the code, replace the MySQL database access code.

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

In addition, access migrates the database in other ways--without moving the database access code of the software system and migrating only the contents of the database, as follows:

(1) As the above method is generally, first in the MySQL database to build and access the same table, and the content also migrated.

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

Figure 3

Figure 4

Figure 5

So, in an Access database, you can see a link to the MySQL database you just created, and then you can do things like manipulate access tables.

Figure 6