I have migrate one site from 7.2 to 9.0 and it is successfully done.
How i can migrate Analytics Database in to new version and in which database?
All data should display as it is in new version as well.
Please provide steps.
Sitecore Stack Exchange is a question and answer site for developers and end users of the Sitecore CMS and multichannel marketing software. It only takes a minute to sign up.
Sign up to join this communityI have migrate one site from 7.2 to 9.0 and it is successfully done.
How i can migrate Analytics Database in to new version and in which database?
All data should display as it is in new version as well.
Please provide steps.
Sitecore (along with DMS Data) should be upgraded together. While the Express Migration Tool looks appetizing, it does not upgrade DMS data.
The important guide for Sitecore Analytics is the xDB Upgrade Guide found for each version. The prerequisites of each guide highlight the upgrade Path.
From Sitecore 7.2, there are a few hoops you have to go through to get to Sitecore 9.
Following the xDB Conversion Guide for 7.5 this will take your solution and migrate DMS data to xDB, which introduces Mongo.
Following this xDB Upgrade Guide will introduce the initial version of Sitecore 8 and upgrade analytics in xDB to 8.0.
Following this xDB Upgrade Guide will bring your Sitecore solution to version 8.1, which has a number of changes related to how analytics are stored.
Following the Sitecore Experience Platform Upgrade Guide will upgrade your solution from 8.1 Initial to Sitecore 9 Initial.
Once your solution is on Sitecore 9, you can use the xDB Data Migration Tool to migrate your 8.1 xDB Data to Sitecore 9.
This will help you get your analytics from DMS to Sitecore XP 9. I would offer a note of caution regarding expectations, the data might not display the same. Your mileage may vary.
I'm not sure if this would even work, or if the data would even make sense. The analytics data model from DMS in 7.2 is nothing like what xDB is now in 9.0. Even if you could somehow run tools to go through versions, I'm not sure you would be able to get value out of the resulting process.
The xDB data migration tool for 9.0 is intended for 8.x where there is a known xDB data model.
There is a tool available to upgrade DMS data to xDB format in 7.5:
https://sdn.sitecore.net/Products/Sitecore%20V5/Sitecore%20CMS%207/Update/7_5_rev_141003.aspx
From there you could upgrade to 8.0 xDB and then try to use the 9.0 migration tool to jump to 9.0 xDB. However, I have no confidence this process would actually work.