Exploration of Access database migration and access database migration

Source: Internet
Author: User

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

Related Article

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.