Need understanding on data migration in hybris

[sharada1234]

Hi Team,

Currently we are working on hybris upgrade from 6.1 to 2105.As part of this We are doing DB migration from Oracle to MSSQL server.

We have already tried to do the data migration from 6.1 oracle DB to new MSSQL DB. But we got type system issues. So now we are doing the data migration from upgraded 2105 Oracle to 2105 initialized MSSQL server DB using AWS DMS tool.

I have few doubts here, need your help to proceed further with the migration.

1.I have identified few changes in columns. For example in units table we have ACTIVEFLAG column in Oracle but in MSSQL server we have p_active column.

2.DO we need to change the column name to ACTIVE FLAG in MSSQL server when doing the data migration because as part of migration we also migrate composed types and attribute descriptors tables where we get ACTIVEFLAG column name in attribute descriptors and if we keep p_active column, system will not identify this column.

3.If we migrate composed types and attribute descriptors, will hybris identify the new type system while doing the system update?

4.First we migrated all tables without migrating composed types and attribute descriptors but I can see some issues while fetching the data from HAC as it is triggering the query on TypePKstring of each table which is PK of composed types.
As you know the TypePKString in a table is a PK in composed types. Due to the difference in PK I am getting no results in HAC.

Please help me to clarify the above points asap.

Thanks,
Sharada

[Amin_Omidy]

Hi Sharada

Please check my recent answer in blog below :

https://answers.sap.com/questions/13800885/issues-after-db-migration-from-oracle-to-mssql-ser.html?c...

Your data types including primary keys and referential integrity should be matched with your Target DB in this case MSSQL Initialization empty tables before importing data from Oracle. Normally primary key and Foreign keys stay same but your data type will follow MSSQL data types otherwise Hybris can not distinguish the records if the data type is different from what Hybris expected in Target DB.

Some thoughts:

• When migrating data from Oracle to MSSQL, it's common to have differences in column names or data types between the two databases. In your case, if the column names are different between Oracle and MSSQL, you'll need to map the Oracle column name to the MSSQL column name during the migration. This can be done using the AWS DMS tool or by writing custom scripts to perform the migration.
• If the column name in MSSQL is different from the column name in Oracle, you'll need to update the attribute descriptors in Hybris to reflect the new column name. This can be done by using the Hybris HMC (Hybris Management Console) or using ImpEx scripts to update the attribute descriptors.
• When you migrate composed types and attribute descriptors, Hybris will recognize the new type system and update its internal metadata accordingly. However, you'll still need to update the attribute descriptors to reflect the new column names in the MSSQL database.
• If you're getting no results in HAC due to the difference in PK between the tables and composed types, you'll need to update the attribute descriptors to reflect the new PK in the MSSQL database. You can use the HMC or ImpEx scripts to update the attribute descriptors. Once the attribute descriptors are updated, you should be able to fetch data from HAC.

Thanks,

[sharada1234]

Hi amin_omidy,

Thanks a lot for your reply. Your answers are really helping me to work on the migration.

We are still facing issues with data migration using AWS DMS tool. So we are thinking to use CMT for data migration.Could you please help us to clarify below points if you have idea.

1.As you suggested that we can use CMT for data migrations but not sure how to setup that.
2.And do we need CCV2 subscription to utilize/setup CMT tool?
3.If we want to use CMT tool for data migration, what is the procedure we need to follow?
4.Will SAP help us to setup the environment for data migration via CMT tool?
5.Is it paid services if we need to take help from SAP expert services to setup the environment for CMT tool?

Please help us here if anybody did the data migration using CMT tool.

Thanks,

Sharada