Balaji's blog - Database migration: From Windows MS Access to Linux MySQL

<< What is the best job in the world | Home | My article on webservices got published in Javaranch... >>

Permalink
[Software Development] Database migration: From Windows MS Access to Linux MySQL

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

./grtsh: error while loading shared libraries: libtercap.sp.2: cannot open shared object file: No such file or directory
./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

Convert ms access database to 'SQL scripts of create and insert statements' and run it using phpmysqladmin
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

TrackBacks[0] Comments[0] Posted by balajidl on 20 March 2006 12:28:49 CET

Add a comment

TrackBack to http://radio.javaranch.com/balajidl/addTrackBack.action?entry=1142854129729

Title
Body	HTML : b, i, blockquote, br, p, pre, a href="", ul, ol, li
Math Quiz 8 + 5 =	(Helps stop blog spam)
Name
E-mail address
Website
Remember me	Yes No
E-mail addresses are not publicly displayed, so please only leave your e-mail address if you would like to be notified when new comments are added to this blog entry (you can opt-out later).