cancel
Showing results for 
Search instead for 
Did you mean: 

Migrate CCOM database from MS SQL to SAP HANA

JoergAldinger
Active Contributor
183

Hello all,

We are recently considering migrating some CCOM databases from MS SQL to SAP HANA. There does not seem to be a documented process for this, or is there?

Here is what we came up with, so far:

  • Create a new CCOM tenant using SAP HANA in the same FP and PL as the original MS SQL tenant (this creates the database structure in SAP HANA).
  • Stop both the original as well as the destination tenant
  • Delete all rows from new schema (basically the Admin user and some initial configuration)
  • Using a tool (developed by us) insert all records from the MS SQL database into the SAP HANA database, whenever the same table and column name exists, taking into consideration the collation differences that may exist.
  • Start destination tenant

So far, everything seems to be working, but I wanted to point out some differences in the DB structure, specifically tables and columns that do not exist in the newly created SAP HANA schema, to see if anybody might be able to tell whether these columns might have been created by an earlier FP and are not required anymore.

  • Table DISPATCH_CONFIGURATION
  • Table DISPATCHABLE_TYPE
  • Column IGNORE_DUPLICATE_RECEIPT_EXCEPTION in table CSCONFIGURATION
  • Column DISPATCH_CONFIG_KEY in table DISPATCH_HEADER_STATUS
  • Column FIELDMAPPING_OBJ_TYPE in table FIELDMAPPING
  • Column DISPATCH_CONFIGURATION_OBJECTKEY in table FIELDMAPPING

The version we used for this test was 2.0 FP10 PL04.

Attached is the log file produced by our tool: tmpc8a9tmp.txt

Your comments are appreciated.

Best regards,

Joerg.

Accepted Solutions (0)

Answers (0)