Database migration: From Windows MS Access to Linux MySQL

1 min read

I had a requirement where I have migrate MS Access database to MySQL
database.

MySQL is running on Linux UBUNTU.

MS Access is located in Windows 2000.

The task is pretty simple, all you have to do is download and install MySQL
migration toolkit
and start running the wizards.

It will work as long as your mysql is installed in windows platform. There is
also yummy
yummy video tutorial
showing this.

What about in Linux ??? , it was not that simple…

Installing mysql migration kit in Debian based linux.  I got two errors
while trying to run the shell script run_migration.sh

  1. ./grtsh: error while loading shared libraries: libtercap.sp.2: cannot open
    shared object file: No such file or directory
  2. ./grtsh: error while loading shared libraries: libjvm.so: cannot open
    shared object file: No such file or directory

The first error can be solved by installing the package apt-get install
termcap-compat.

The second error can be solved by installing the jre plugin for linux os. If
you still happen to receive that error, edit the run_migration file to locate to
your jre installation as shown below..

Now you will be able to run the mysql migration toolkit wizard…

If you follow the wizard of migration ms access database to my sql database,
you will get an error saying ..

./run_migration: line 11: 30923 Segmentation fault   ./grtsh -x
scripts/TextMigrationScript.lua

I searched net to find a solution for this, no light yet. I guess the problem
is because of running the toolkit in linux os(?) where the toolkit is not
capable of reading the window ms access file format(?).

So I found two alternative solutions

  1. Convert ms access database to ‘SQL scripts of create and insert
    statements’ and run it using phpmysqladmin
  2. Convert ms access database to MS SQL Server database and use the migration
    toolkit to locate the ms sql server database and migrate the data.

The first option will work provided you have ample time and thrid party
tools.

The second solution is simple as all you can easily convert ms access
database to ms sql server database. (Note I have two PC’s here, one running
debian linux
and other MS Windows 2000)

Below is some screenshots showing the steps  involved in converting
database from MS SQL Server to MySQL as

Statup screen

Specify ms sql server database location

choose the destination database

destination database locations

Related posts:

Leave a Reply

Your email address will not be published. Required fields are marked *