I am using jackcess to convert an access database to a mysql one.
I am able to read the Db and extract the name of the tables and the rows of each of them, but I don't know how to create, in the easy wa,y the tables in mysql mapping the ones in access (type of the fields, primary keys, constraints etc.)
Can someone help me? Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hopefully the utility code in Jackcess which does the reverse operation can give you some ideas how to do the conversion: http://jackcess.sourceforge.net/xref/com/healthmarketscience/jackcess/util/ImportUtil.html#83 . Also, note that the Column's DataType has a "sql type" value which is the appropriate JDBC data type (along with the length, scale, and precision attributes).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am using jackcess to convert an access database to a mysql one.
I am able to read the Db and extract the name of the tables and the rows of each of them, but I don't know how to create, in the easy wa,y the tables in mysql mapping the ones in access (type of the fields, primary keys, constraints etc.)
Can someone help me? Thanks
Hopefully the utility code in Jackcess which does the reverse operation can give you some ideas how to do the conversion: http://jackcess.sourceforge.net/xref/com/healthmarketscience/jackcess/util/ImportUtil.html#83 . Also, note that the Column's DataType has a "sql type" value which is the appropriate JDBC data type (along with the length, scale, and precision attributes).