Exploration of Access database migration and access database migration
Background: 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 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. Figure 1. Figure 2
Figure 1
Figure 2
You can also use an Access2MySQL tool to import data.
(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:
Figure 3
Figure 4
Figure 5
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.
Figure 6
----------------------
Additional information. If you want to migrate the MySQL DATA table to the MsSQL database, here is a case shared by a user.
Http://www.foxtable.com/bbs/dispbbs.asp? Boolean id = 2 & id = 35184
Import and migration of the website access Database
The ac database is the same as the word database. It is OK to copy it directly.
Access data migration
It took me an hour to convert my site database access to mysql base and code without changing it. Just change the database link page.
In fact, if you think about it carefully, access is developed by Microsoft and mysql is its upgraded product, there must be a bridge between the two products to achieve their conversion.
Open your access database first, and then export the tables in the database one by one. Note that the file type to be saved is the bottom "ODBC datebases () "The following sections will be done by yourself. If there is an SQL type, select it. open SQL Enterprise Manager, create an empty database, and then select import ...... it's easy to do it by yourself.
There are too many words to write, and you can find them by yourself. Don't know how to add me QQ: I'll give it to you
My QQ: 108908332