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,

Here is my answers:

1.As you suggested that we can use CMT for data migrations but not sure how to setup that.: The detail instruction is in :

https://github.com/SAP-samples/commerce-migration-toolkit
2.And do we need CCV2 subscription to utilize/setup CMT tool? NO id an open Source
3.If we want to use CMT tool for data migration, what is the procedure we need to follow? Just follow the GitHub instruction please
4.Will SAP help us to setup the environment for data migration via CMT tool? This a free tools SAP provide for Hybris Customers if you need to get any support you need purchase or contact SAP ecommerce :

https://help.sap.com/docs/SAP_COMMERCE_CLOUD_PUBLIC_CLOUD/265a2902eb8d41a3bf79c5e5320785fa/497d536ea...
5.Is it paid services if we need to take help from SAP expert services to setup the environment for CMT tool? You can do migration by using this tool if you can follow the instruction with you hands on

Hope this helps,