migrate database from Sybase to MySQL
I have been trying to migrate a database from Sybase to MySQL.
This is my appr开发者_Python百科oach:
- Generate pojo classes from my Sybase database using hibernate in eclipse
- Use these pojo classes to generate the schema in MySQL database
- 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.
- I added hibernate plugin in eclipse from this link: [http://download.jboss.org/jbosstools/updates/stable/][1]
- I added Sybase jar file to my project classpath
- Then I added hibernate console configuration file
- Then I added hibernate configuration file
- 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 am not able to find any solution. Can anybody tell me what mistake I am making here or point to some hibernate tutorial for eclipse??
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
精彩评论