How to export Northwind Access database to MySQL
Inside This Article
Export Northwind Access database to MySQL via ODBC
In this article, we are going to export the popular Microsoft Access Northwind database to MySQL server.
If you can't wait, you can grab the completed and normalized MySQL Northwind script and the image files now.
If you have the patience and want to learn the real meat about how to export and how to create a true relational Northwind database in MySQL, continue reading.
Software you need for the migration
Steps to Migration Northwind to MySQL
There are three major steps here. Skip the step that you have done.
Step #1: Install MySQL ODBC 3.51 Driver.
For detailed information about DSN setup, see how to set up DSN in ODBC Data Source Administrator on Windows.
MySQL Connector/ODBC (MyODBC driver) is the ODBC driver for MySQL databases. It can be used by various ODBC-compliant applications to connect to a MySQL database and work with data stored in the database.
You can download and install MySQL ODBC Driver from MySQL.com website.
Step #2: Create blank Northwind database in MySQL server.
One of the easiest ways to create a new database in MySQL is use open source SQLyog. Create a blank database and name it Northwind.
Step #3: Create Data Source Name (DSN) in ODBC for Northwind database.
DSN is the name to the connection details of a database. When connecting to the database, ODBC-compliant applications simply refer to a DSN to obtain connection details.
To learn how to set up DSN for Northwind database, see How to set up DSN in ODBC Data Source Administrator.
Step #4: Export Northwind tables from Access to Northwind database in MySQL.
Here we are going to export tables in Northwind database in Access to Northwind database in MySQL. There are eight tables and we will have to export them one by one.
Below demonstrates how to export Categories table. Follow the same steps to export other tables.
A quick look at the table structures reveals:
In next step, we will write scripts
to turn MySQL Northwind database into a true relational database. These include changing all tables to InnoDB table type,
adding primary keys and foreign keys, adding default constraints and indexes, and more.
Copyright © 2017 GeeksEngine.com. All Rights Reserved.
This website is hosted by HostGator.
No portion may be reproduced without my written permission. Software and hardware names mentioned on this site are registered trademarks of their respective companies. Should any right be infringed, it is totally unintentional. Drop me an email and I will promptly and gladly rectify it.