How Can I Add All North Wind Db Into My Newly Installed Mysql Server

Question

1.00/5 (2 votes)

See more:

I have Northwind Access file and newly installed MySQL server.

I would like to add all Northwind DB including all relationships and etc into MySQL.

simple query will do enough I guess, but I am an novice in DB field.

anyone knows how to do that?

Your help and advice will do a lot to my work.

Thanks in advance.

Posted 13-Sep-14 13:31pm

조덕희

Updated 13-Sep-14 14:39pm

Garth J Lancaster

v2

Add a Solution

Comments

[no name] 13-Sep-14 20:38pm

You call us nasty names and want help? Yeah, good luck with that.

Garth J Lancaster 13-Sep-14 20:42pm

not sure if he was calling 'us' so much nasty names, or himself, as I would have been calling myself (internally) if I'd messed up like that - Ive removed the offensive bit anyway

3 solutions

Solution 2

thank you. and I regret my bad languages and I am sorry If I offended you.

Have a good day!

Posted 13-Sep-14 14:41pm

조덕희

Comments

Garth J Lancaster 13-Sep-14 20:52pm

btw - MySQL have something here http://www.mysql.com/why-mysql/white-papers/a-guide-for-migrating-from-microsoft-access-to-mysql/ - that showed up on a quick google search I did - I believe it uses ODBC as I said, so I'd start with that

조덕희 13-Sep-14 20:55pm

exactly what i am searching for. you help me a lot. Thank you!

Solution 3

https://twitter.com/tradeblash/status/510959404733038592[^]

Posted 13-Sep-14 15:14pm

조덕희

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Garth J Lancaster · Accepted Answer · 2014-09-13T14:38:00

yikes - you might find a custom made migrate tool, otherwise you're going to have to do it in steps

a) install an ODBC driver pointed at the Northwind DB
b) maybe use MS SQL Express temporarily and the TSQL on the command line to dump the data and meta data (Table defs)to disk, if MS SQL Express can 'import'/attach to the Northwind.mdb (I cant remember if it can)
c) turn the table defs into MYSQL equivalent and build the tables
d) import the data into the tables

Im surprised
a) there isn't a DB migrate tool out there, I'd be exhausting that option first
b) someone hasn't done it and can supply you the data already in MYSQL format

sorry, those are only rough notes on the sort of things you need to do, no necessarily what tools are going to be appropriate

lastly, please watch the language in your posts !!!