• 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic