Changing DB

Ranch Hand

Posts: 223

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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?

Thank You<br />Edward

Edward Durai

Ranch Hand

Posts: 223

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Give me some idea.

Thank You<br />Edward

Emanuel Kadziela

Ranch Hand

Posts: 187

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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.