Data migration from MS Access to SQL

Tagged:

It's time to use SQL databases. Here are one of the methods of data migration from MS Access to SQL.

Install mdbtools package:

# apt-get install mdbtools

Get mdb2sql.py. Then execute:

$ python mdb2sql.py my.mdb

The script put the result in my directory, according to mdb file name.

Good luck.