Re: Automatically Migrate from Access to MySQL

[DJ McClain]

Thanks for you help Michael. I managed to get a bit further with what you responded to Steve. I had my script in the wrong place. Here's what happened when I ran grtsh -verbose migrateSchedule.lua.

MySQL Generic Runtime Environment 2.0.11 beta

Type 'help' or '?' for help. Type 'quit' to exit the shell.

Scanning for struct definitions in ./xml ...
Registered 10 struct definition files.
Initializing Builtin modules...
Initializing Java loader...
Launching Java VM
Classpath: -Djava.class.path=.;./java;./java/lib\jtds-1.1.jar;./java/lib\junit.j
ar;./java/lib\mysql-connector-java-3.1.11a-bin.jar;./java/lib\mysql-grt-java-1.0
.0-bin.jar;
Runtime Library filename: C:\Program Files\Java\j2re1.4.1_02\bin\client\jvm.dll
Scanning for Java modules in ./java/com/mysql/grt/modules ...
Scanning module directory ./java/com/mysql/grt/modules.
Trying to load module ./java/com/mysql/grt/modules\BaseJava.class.
Initialized module com/mysql/grt/modules/BaseJava
Trying to load module ./java/com/mysql/grt/modules\JavaTestModule.class.
Initialized module com/mysql/grt/modules/JavaTestModule
Trying to load module ./java/com/mysql/grt/modules\JavaTestModuleTest.class.
Module ./java/com/mysql/grt/modules\JavaTestModuleTest.class doesn't implement g
etModuleInfo
Trying to load module ./java/com/mysql/grt/modules\MigrationAccess.class.
Initialized module com/mysql/grt/modules/MigrationAccess
Trying to load module ./java/com/mysql/grt/modules\MigrationGeneric.class.
Initialized module com/mysql/grt/modules/MigrationGeneric
Trying to load module ./java/com/mysql/grt/modules\MigrationMssql.class.
Initialized module com/mysql/grt/modules/MigrationMssql
Trying to load module ./java/com/mysql/grt/modules\MigrationMysql.class.
Initialized module com/mysql/grt/modules/MigrationMysql
Trying to load module ./java/com/mysql/grt/modules\MigrationOracle.class.
Initialized module com/mysql/grt/modules/MigrationOracle
Trying to load module ./java/com/mysql/grt/modules\MigrationOracleTest.class.
Module ./java/com/mysql/grt/modules\MigrationOracleTest.class doesn't implement
getModuleInfo
Trying to load module ./java/com/mysql/grt/modules\MigrationUtils.class.
Module ./java/com/mysql/grt/modules\MigrationUtils.class doesn't implement getMo
duleInfo
Trying to load module ./java/com/mysql/grt/modules\ReverseEngineeringAccess.clas
s.
Initialized module com/mysql/grt/modules/ReverseEngineeringAccess
Trying to load module ./java/com/mysql/grt/modules\ReverseEngineeringAccessTest.
class.
Module ./java/com/mysql/grt/modules\ReverseEngineeringAccessTest.class doesn't i
mplement getModuleInfo
Trying to load module ./java/com/mysql/grt/modules\ReverseEngineeringGeneric.cla
ss.
Initialized module com/mysql/grt/modules/ReverseEngineeringGeneric
Trying to load module ./java/com/mysql/grt/modules\ReverseEngineeringMssql.class
.
Initialized module com/mysql/grt/modules/ReverseEngineeringMssql
Trying to load module ./java/com/mysql/grt/modules\ReverseEngineeringMysqlJdbc.c
lass.
Initialized module com/mysql/grt/modules/ReverseEngineeringMysqlJdbc
Trying to load module ./java/com/mysql/grt/modules\ReverseEngineeringOracle.clas
s.
Initialized module com/mysql/grt/modules/ReverseEngineeringOracle
Trying to load module ./java/com/mysql/grt/modules\ReverseEngineeringOracleTest.
class.
Module ./java/com/mysql/grt/modules\ReverseEngineeringOracleTest.class doesn't i
mplement getModuleInfo
Trying to load module ./java/com/mysql/grt/modules\TransformationMysqlJdbc.class
.
Initialized module com/mysql/grt/modules/TransformationMysqlJdbc
Registered 13 modules.
Initializing Lua loader...
Scanning for Lua plugins in ./lua ...
Scanning module directory ./lua.
Trying to load module ./lua\BaseLua.lua.
Trying to load module ./lua\Migration.lua.
Trying to load module ./lua\RdbmsInfo.lua.
Trying to load module ./lua\RdbmsInfoAccess.lua.
Trying to load module ./lua\RdbmsInfoGeneric.lua.
Trying to load module ./lua\RdbmsInfoMssql.lua.
Trying to load module ./lua\RdbmsInfoMysql.lua.
Trying to load module ./lua\RdbmsInfoOracle.lua.
Trying to load module ./lua\RdbmsManagement.lua.
Registered 9 modules.

Opening script file migrateSchedule.lua ...
Executing script file migrateSchedule.lua ...

Set source connection.
Set target connection.
Test source connection to Access ...
Initializing JDBC driver ...
Driver class MS Access
Opening connection ...
Connection jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:Docu
ments and SettingsmcclaidjDesktopcourseSchedule.mdb;DriverID=22;READONLY=true;UI
D=%username%;PWD=%password%}
ERROR: The connection to the source Access database could not be established.
"[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'."
"sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
sun.jdbc.odbc.JdbcOdbcConnectio