Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sybase Db dump/restore between hp-ux and window NT Platform

Status
Not open for further replies.

gj2007

IS-IT--Management
Apr 14, 2003
2
AU
Is it possible to Restore HP-UX Sybase DB dump on Windows NT Sybase (ASE 11.9)


 
No I am afraid it is not. You cannot even dump and load from one flavour of UNIX to another one, for example from ASE on Solaris to ASE on AIX etc.

The best bet it to reverse enginner all the objects (tables, triggers, sps etc), create the database on ASE on WINNT and bcp data into tables. It is rather long winded. More for one off migration than nightly operation.

Once you have loaded the original dump on WINNT you can use sybase replication server setup to keep both databases in sync. Sybase replication server allows you to exchange data on different O/S


Good luck
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top