BCM to CRM 4.0 - how do I migrate the "old" data
Posted on 2008-06-15
I installed a new CRM 4.0 Server and that part went really fine (when I got all the red exclamation marks from CRM-Installation away :))
Then I wanted to import the "old" BCM data in the new server. I started an export - I was happy to find a full export with history in BCM - I got a nice BCM file as result of the export.
The real problems started when I tried to reimport the BCM data in CRM 4.0 with the Data Migration Wizard:
1.) The wizard does not accept BCM files where all the infos are in.
2.) I lose the connection between account and contact when I use the csv files I can export from BCM
So I used the BCM file and made an .xml out of it (just renaming) - I imported the XML in MS Access to get the structure of the old data. Then I used the GUIDs from the XML and brought them back in the csv exported files from BCM (because in the XML file all emailadress were in a different table without GUIDs)
Finally I had a 2 nice files - one for accounts and one for contact in csv format. The import worked and I got almost all data in.
But how do I get the history and everything else in??? Emails, photos and all links to files are missing. How can MS make a big brother of BCM and forget the tools to let the little brother grow????
I hope someone can give me a solution!
Thanks in advance