migrate database from sybase to mysql

Question

I have been trying to migrate a database from sybase to Mysql.

This is my approach:

1. Generate pojo classes from my sybase database using hibernate in eclipse
2. Use these pojo classes to generate the schema in mysql database
3. Then somehow migrate the data from sybase to mysql

I guess this approach should work??? Please let me know if there is any better or easier approach.

The thing is I am not even able to get the first step done.

1. I added hibernate plugin in eclipse from this link: [http://download.jboss.org/jbosstools/updates/stable/][1]
2. I added sybase jar file to my project classpath
3. Then I added hibernate console configuration file
4. Then I added hibernate configuration file
5. Then I added hibernate code generation configuration

When I try to run the code generation configuration file, I am getting java.lang.NullPointerException and I have no idea how to fix it.

I searched a lot of forums, tried to google it, but I not able to find any solution. Can anybody tell me what mistake I am making here or point to some hibernate tutorial for eclipse??

Answer 1

one method would be to run a sql export on the database, change the schema as necessary, and then import the data into mysql.

if that's not acceptable, where are you getting the NPE?

edit: alternatively, try this page