Move Data From Old Hybris Instance to New Hybris Instance

[Former Member]

Hi Experts ,

I am migrating from 5.7 to 6.2 , I need to Migrate the data from Old Version to New Version , need to know any way it can be done ?

Thanks ,

D

[Former Member · Accepted solution]

Hi Arun,

There are many approaches to this and a lot of variations from project to project so this answer is high level.

First you will want to utilize a native db tool to migrate the data from the current system. All of the supported databases have them. Check with your vendor for the supported tool. This will allow you to move data from one database to another but assumes that you are migrating the same database i.e. hana -> hana or mysql -> mysql. If that is not the case then this answer does not apply and you should look for some more powerful data migration tools.

Install the new version of hybris and configure it to use the migrated schema and data. The next step would be to run a system update. You can read more about this here: https://help.hybris.com/6.7.0/hcd/08c89599782a4d589a2d5651899d02f1.html

It is possible if you are very lucky that your target system will stnd you can use the hac to run this command. More likely you will have to run a headless hybris ant update. Most likely this will fail too. However you can run ant updatesystem -DdryRun=true which will not actually run the update but provide a DML script that you can run against the target data manually. This will allow you to identify and fix the bits that are failing. You will need decent knowledge about the db system that you are using and you will need a repeatable process. This means that you should have the ability to restore and start over using the original data created in the first step. This can be a challenge since production databases tend to be large so plan accordingly. Once the DML scripts are run then you should be able to start up the hybris system and run a system update from the hac.

Some important considerations

1. Your production data will have live customer data make sure you understand what happens in the system before starting the target system. You don't want to send emails to all the customers because a cronjob kicks off.

2. Passwords can be tricky. Many times a customer will increase user password protections since newer versions of hybris support better hashing algorithms. There is no easy answer to this and you will have to work with the business and define detailed migration reqs.

3. Promotions: Promotions changed significantly in your version migration so again work with the business to understand what is required for these.

4. It will take longer than you think. It is hard to estimate and challenging so be careful when providing timelines.

5. Before running the update process look at the accelerator data and make sure that it does not get into your production system. Understand what happens during a system update thoroughly. Being able to fail and iterate on this is essential.

Hope that helps.