4

I have 2 databases, one is MS Access DB from an old website, and the other one is MYSQL from the new Joomla+VirtueMart based website. I need to migrate existing products from MS Access to MYSQL.

I thought of putting both on server and writing SQL queries in MYSQL workbench, untill I have a good script for that, but I'm very new to SQL, so I'd rather avoid that.

I there a better way and more efficient for that?

Improve this question

4 Answers 4

Reset to default
4

You can always export to CSV and import that in MySQL.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

3

you can use tools like Database Workbench

Improve this answer

Comments

1

MySQL provides a free graphical tool called "MySQL Migration toolkit" which automates the migration of Access 2003 MDB files (schema + data) into MySQL. More info at the following link:

http://www.mysql.com/why-mysql/white-papers/a-guide-for-migrating-from-microsoft-access-to-mysql/

(you need to register with Oracle to download the PDF guide).

Improve this answer

Comments

1

Here's another link using the ODBC technology

https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-export.html

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.