MS Access migration using the HXTT Access JDBC3.0 package
Posted by: Yonghong Zhao
Date: October 26, 2005 08:46AM

HXTT Access contains the only type 4 JDBC(1.2, 2.0, 3.0) driver packages for Microsoft Access version from 2.0, 95, 97, 2000, XP, 2002, to 2003, which supports transaction, embedded access, and remote access.

Installation Guide:
1. Donwload mysql_migration.zip file from http://www.hxtt.net/test/mysql_migration.zip .
2. Unzip mysql_migration.zip file to C:\ directory if your MySQL Migration Toolkit is installed C:\MySQL Migration Toolkit 1.0\ directory.
3. Download Access_JDBC30.jar from your http://www.hxtt.net/access.html , and copy it to C:\MySQL Migration Toolkit 1.0\java\lib directory.
4. Then start MySQL Migration Toolkit to begin your data migration.
5. If you use only those packages to do simple data migration for MySQL, you needn't to know more since you have experience on using MySQL Migration Toolkit. If you wish to set advanced connection properties, you should refer HXTT JDBC Development Document too. Both of HXTT JDBC packages and Development Document are availabe at http://www.hxtt.net/products.html.

Note for MS Access:
1. If your MS Access database file is encrypted by MS Access, you should use MS Access to decrypt that database manually first.
2. If your MS Access database file is protected with a password by MS Access, you should provide the correct password in MySQL Migration Toolkit too.

Options: ReplyQuote


Subject
Written By
Posted
MS Access migration using the HXTT Access JDBC3.0 package
October 26, 2005 08:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.