Skip to main content

Migrating from MS Access (*.mdb,*.accdb) To MySQL database

This article describing how to use ESF Database Migration Toolkit to migrating data from MS-Access 2000-2007 to MySQL database and vice versa.

Introduction:

If you have not installed ESF Database Migration Toolkit, get it nowdownload.
1). In "Choose a Data Source" dialog, choose "Microsoft Access (*.mdb)" or "Microsoft Access 2007 (*.mdb;*.accdb)" if you are migrating data from Access 2007; Then press "Browse" to find the Access MDB (or ACCDB) file, if the file has a password, fill out password in "Password" field, then click "Next" to continue.
2). In "Choose a Data Destination" dialog, choose "MySQL Database", fill out the server name where MySQL locating and the server port (default is 3306), plus, you want to offer a username and password to connect it. MySQL supporting some different Storage Engines, please click here to get more information about MySQL Storage Engine. In "CharacterSet" field choose a character set like UTF-8(Notice: the chararacter set must be same as the MS Access database, otherwise, it will lost some characters when converting). Press "Refresh" button, this program will enumerate all databases locating in the MySQL server automation, you can select a database directly, or input a new database name in "Database" field, this program can create the new database in converting. Click "Next" to continue.
3). In "Select source Tables(s) & View(s)" dialog, it is listing all the tables and views in the MS Access database, you can preview source table data via "Preview" button. Selecting the tables or views that you are preparing to convert. In here, you have a chance to change the destination table name at "Destination" column. There is an "Overwrite Database" option below the list (Notice: When you check this option, the destination MySQL database will be removed, and all data will lose!). If you want to set more options for conversion, click "..." button at "Transform" column immediately.
4). In "Transform" dialog, there are some useful options for your conversion. You can only convert table structure via check "Copy Structure Only" option, or check/uncheck "Copy Indexes"/"Copy Foreign Keys" to enable/disable copy MS Access indexes/foreign keys when converting. The "Transfer auto-increment" option is most usefully for you when you converting a MS Access table with a auto-increment field (e.g.: ID), sometimes, when you append data to a MySQL table with auto-increment, perhaps you will receive a message like "Duplicable-keys...", you can uncheck this option to resolve it. Plus, you can change table/column case in "Table/Column Name" option or give a data filter (e.g.: id<100 1="1)." all="" allow="" and="" be="" can="" choose="" click="" data="" default="" done="" ecords="" empty="" etc="" f="" field="" fields="" filter="" ield="" in="" let="" list="" map="" migrate="" migrated="" name="" null="" option="" or="" p="" precision="" save="" settings.="" size="" table="" the="" this="" to="" type="" value.="" want="" when="" which="" will="" you="" your="">
5). In "Execution" Dialog, click "Submit" to starting the MS Access to MySQL conversion. When conversion is running, click "Stop" to stop the conversion.
6). To converting from MySQL to MS Access(*.mdb, *.accdb), just choose" MySQL Database" in "Choose a Data Source" page and choose "Microsoft Access (*.mdb)" or "Microsoft Access 2007 (*.accdb)" in "Choose a Destination" page , Other settings is same as above.

curtsy: easyfrom

Comments

Post a Comment

Popular posts from this blog

Financial Engineering

Financial Engineering: Key Concepts Financial engineering is a multidisciplinary field that combines financial theory, mathematics, and computer science to design and develop innovative financial products and solutions. Here's an in-depth look at the key concepts you mentioned: 1. Statistical Analysis Statistical analysis is a crucial component of financial engineering. It involves using statistical techniques to analyze and interpret financial data, such as: Hypothesis testing : to validate assumptions about financial data Regression analysis : to model relationships between variables Time series analysis : to forecast future values based on historical data Probability distributions : to model and analyze risk Statistical analysis helps financial engineers to identify trends, patterns, and correlations in financial data, which informs decision-making and risk management. 2. Machine Learning Machine learning is a subset of artificial intelligence that involves training algorithms t...
Post a Comment
Read more

Wholesale Customer Solution with Magento Commerce

The client want to have a shop where regular customers to be able to see products with their retail price, while Wholesale partners to see the prices with ? discount. The extra condition: retail and wholesale prices hasn’t mathematical dependency. So, a product could be $100 for retail and $50 for whole sale and another one could be $60 retail and $50 wholesale. And of course retail users should not be able to see wholesale prices at all. Basically, I will explain what I did step-by-step, but in order to understand what I mean, you should be familiar with the basics of Magento. 1. Creating two magento websites, stores and views (Magento meaning of website of course) It’s done from from System->Manage Stores. The result is: Website | Store | View ———————————————— Retail->Retail->Default Wholesale->Wholesale->Default Both sites using the same category/product tree 2. Setting the price scope in System->Configuration->Catalog->Catalog->Price set drop-down to...
Post a Comment
Read more

How to Prepare for AI Driven Career

  Introduction We are all living in our "ChatGPT moment" now. It happened when I asked ChatGPT to plan a 10-day holiday in rural India. Within seconds, I had a detailed list of activities and places to explore. The speed and usefulness of the response left me stunned, and I realized instantly that life would never be the same again. ChatGPT felt like a bombshell—years of hype about Artificial Intelligence had finally materialized into something tangible and accessible. Suddenly, AI wasn’t just theoretical; it was writing limericks, crafting decent marketing content, and even generating code. The world is still adjusting to this rapid shift. We’re in the middle of a technological revolution—one so fast and transformative that it’s hard to fully comprehend. This revolution brings both exciting opportunities and inevitable challenges. On the one hand, AI is enabling remarkable breakthroughs. It can detect anomalies in MRI scans that even seasoned doctors might miss. It can trans...
Post a Comment
Read more