JDbConvert Documentation Version 0.1
JDbConvert is an command line database converter based on Java and JDBC. It
should be able to convert from any database to any database, but there are some
differences between the DBMS that need to adapt every DBMS. Currently we have
test it with Small SQL, MS Access and MS SQL Server. More database are follow.
Currently are supported:
Other DBMS will work with generic data types. It will only for tables because there is no standard in the JDBC interface to scan the structure of a view.
java -cp JDbConvert.jar;yourdriver.jar JDbConvert [-options]
The follow sample kopiert the databse form the ODBC DataSource "mssql" to the ODBC DataSource "access"
java -cp JDbConvert.jar JDbConvert -srcurl jdbc:odbc:mssql -srcuser sa -desturl
jdbc:odbc:access -drv smallsql.server.SSDriver -drv sun.jdbc.odbc.JdbcOdbcDriver