cancel
Showing results for 
Search instead for 
Did you mean: 

SAP ASE 16 cross platofrm dump to Google cloud

jmtorres
Active Participant
0 Kudos
401

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

Accepted Solutions (1)

Accepted Solutions (1)

sladebe
Active Participant

The cloud is not really relevant. This just a cross platform dump/load. Take a look at the doc page:

Sys admin vol 2 -> Using the dump and load Commands -> Dumping and Loading Databases Across Platforms

There are some restrictions and some special procedures are sometimes required.

jmtorres
Active Participant

Thank you Ben

Answers (1)

Answers (1)

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