Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Changing DB

 
Edward Durai
Ranch Hand
Posts: 223
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Experts,

Currently I am working On Ship Management Project. It Consist lot ot Table Using Hibernate with Struts. Back-End is Oracle Database.

If I want to change the Back-End in SyBase or Any, without creating Tables. That is copy Oracle Tables to Sybase. I don't go to again creating the same tables manually in sybase .Is it possible?
 
Edward Durai
Ranch Hand
Posts: 223
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Give me some idea.
 
Emanuel Kadziela
Ranch Hand
Posts: 187
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, you will have to create this other database somehow and it will have to have the same tables (schema). Your best bet is to try using the hibernate schema generating tools to generate vendor specific schema based on your mapping files and target vendor. You can probably use that auto-generated schema to quickly build an equivalent database on any other server.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!