Access database migration

Source: Internet
Author: User
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.

  

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.