I have one more problem... Im doing a Database Migration from HSQL to DERBy..
Some of the tables in my Source Database(HSQL) have reserved words like "USER", "CLOSE", "OPEN"...etc
When I migrate the database to DERBY which is my destination DB Im getting trouble with these reserved words... the table which have these reserved words raises exception..and the table is never created..
Any solution to check for the fields which are reserved words ?
Please let me know...
[ August 01, 2006: Message edited by: Sudheer Yeddu ] [ August 01, 2006: Message edited by: Sudheer Yeddu ]
A Moment's insight is sometimes worth a Life's experience.
Database migration is nontrivial, especially with create table statements and stored procedures. You could check online documentation for a list of reserved words. As far as converting the data, if you have a large enough set of data you might consider writing a tool that reads the exported SQL data, and does the conversion for you, else you have to do it by hand.