Data migration to New HANA appliance without reloading all tables

[Former Member]

Hello ,

We are replacing our old HANA (SP6) appliance with new platform (SP11). We are restoring data into new HANA from the full backup of the old server.

If we use the existing SLT server , Is it possible to replicate the records to both old and new HANA (only for production for few weeks) without reloading all tables into new HANA? New configuration with same name successfully connected to both HANA servers but the new one shows only the three default DD tables in replication. Is there any better way to do this migration without impacting the current production using same SLT server ?

Please let me know your thoughts , Appreciate your time on this .

Thanks

Thomas

[Former Member · Accepted solution]

You can create a 2nd configuration in SLT connected to the new HANA database.  Then rather than starting replication the normal way for the tables you were previously replicating,   you will insert some records directly into a table in the new HANA table.  It will start replication without doing an initial load.  (Basically a delta from that point forward).  

insert into "TC2"."RS_ORDER" values('QW1','uxqw1ci_QW1_52','CDPOS',0,'T','COLUMN','N','E')

insert into "TC2"."RS_ORDER" values('QW1','uxqw1ci_QW1_52','CDPOS',0,'M','COLUMN','N','E')

insert into "TC2"."RS_ORDER" values('QW1','uxqw1ci_QW1_52','CDPOS',0,'Q','COLUMN','N','E')

You'll have to change the schema / table / SAP Instance in the above SQL.

The trick is that you will have to do this as soon as you copy the data from the old HANA to the new HANA.  Otherwise there will be a gap.

[Former Member · Accepted solution]

Thanks Andrew .

we will perform this to try the parallel load from same source to existing and new HANA systems.

[FKR]

Hi all,

the link to the document referred to above is outdated. It can now be found here:

https://help.sap.com/doc/6a30dd8845174864a0ee77c21f2fcbbf/3.0.08/en-US/Resuming_Replication.pdf

Or, on the SLT Product Homepage help.sap.com/sapslt -> Additional Information:

• Resuming Replication Without Initial Load After System Refresh or OS/DB Migration

Fabian

[Former Member]

Hello Thomas,

If i understand correctly... you want to migrate from OLD HANA appliance to new hana Appliance using back up restore method and you dont want to have reload the SLT tables./

Basically when u back and restore the HANA data base the tables are already present it the new HANA system. you just need to repoint the existing replication server's DBCO connection to new HANA host and that should do it to solve the purpose .

I have tested this scenario

Please  let me know if you need more infor

Amar

[Former Member]

Hello Amar,

Thanks for the details. We could do this referring the below link

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10c14106-564e-3310-cf86-be80a6c27...

If the host or instance number of the target system has changed, the existing database connections must be adjusted accordingly. You can do this in the SAP LT Replication Server Cockpit (transaction LTRC). On the tab page Expert Functions , choose the expert function Change Settings for Connection to Target System

Then

if you have completed the all preparatory steps described above, the corresponding status flags for the SAP LT Replication objects have to be reset. To reset the synonym status, execute the expert function

Reset Status of Tables and Synonyms  in the LT Replication Server cockpit (transaction LTRC). Enter the relevant mass transfer ID, and select the following checkboxes:

·Reset “In Process” Flag

·Reset “Failed” Flag

·Reset Table/Syn. Receiver

Thanks

Prathish