All geek questions in one place

Databases: Transferring data between MS Access DB and MYSQL

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

I thought about posting on the server and writing SQL queries in MYSQL Workbench until I have a good script for this, but I'm very new to SQL, so I would rather avoid this.

Do I have a better way and more efficient for this?

+4
source share
4 answers

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

+4
source

you can use tools like Database Workbench

+3
source

MySQL provides a free graphical tool called the MySQL Migration Toolkit, which automates the migration of Access MDB files (schemas + data) to MySQL. Additional information 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 manual).

+1
source

Source: https://habr.com/ru/post/1334228/

More articles:


All Articles