cancel
Showing results for 
Search instead for 
Did you mean: 

SAP ASE 16 cross platofrm dump to Google cloud

jmtorres
Active Participant
0 Kudos

Hello,

Is it supported to take a dump database from an ASE 16.x running on HP-UX 11.31 -on premise- & then load it into an ASE 16 running on Linux( RHEL or SusE) in a GCP?( it might be AWS or Azure as well)

Thank you

Jose

hrollizo
Active Participant

Hi,

the best option is to do a Homogeneous system/copy using backup/restore or export/import, because you will change the OS.

Best regards

View Entire Topic
0 Kudos

HP is big-endian while Linux is little-endian. This means that you will have to do, as Ben says, a cross platform dump and load. But we never finished the project and hence there are some restrictions. The main one is that we only added log transalation for a couple of records, like the beginxact and some stuff related to statistics. So, there is no way to translate log records and hence, you have to have a completely quiesced database. Then you will have issues with indexes, that will have to be recreated, and if you store some data in native format in image fields, that will not be understood either. So, there is a documented process to checkpoint the database before you dump it (and some systabstats records could be logged, and that is why we ended up translating that record) and after loading, there is also a documented way to recreate indexes.

Then you can pray, and if it doesn' t work, you will have to use some export/import.

jmtorres
Active Participant
0 Kudos

Thanks Carlos,

We have alredy done this kind of migration from LE to BE and with some extra steps, it has run smoothly.

The new element in this case was the use of GCP.

Regards