?
Solved

BCM to CRM 4.0 - how do I migrate the "old" data

Posted on 2008-06-15
9
Medium Priority
?
2,005 Views
Last Modified: 2013-11-24
Hi Gurus,

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

0
Comment
Question by:Plastikboot
  • 5
  • 4
9 Comments
 
LVL 9

Expert Comment

by:Biffster007
ID: 21789812
Hi,

There are a number of ways you can import data into CRM.

1) Using the import wzard which you've already done.
2) Use a third party product like Scribe Migrate or a tool from C360.
3) Write your own import assembly.  This is what I walways do and find it's definitely the most flexible way of doing it.

Cheers,
MH
0
 

Author Comment

by:Plastikboot
ID: 21789972
But how do I split the BCM and most important how do I import the compressed rich text?
0
 
LVL 9

Expert Comment

by:Biffster007
ID: 21789993
Hi,

You're going to have to extract the BCM data into a database of some description, SQL Server would be good, and run imports into CRM from there.  There is a 'Text' datatype in CRM which will hold your compressed rich text.

MH
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 

Author Comment

by:Plastikboot
ID: 21793783
I really wanted to use the migration wizard but even when I use the text-field option I still get the compressed data in crm - so nothing is decompressed. Is there a way to use the import wizard??
0
 
LVL 9

Expert Comment

by:Biffster007
ID: 21797519
The import wizard is quite limited unfortunately, hence the reason I opt for writing my own assemblies.

By 'compressed' what do you actually mean??  Can you not extract into a CSV file and import from there??

MH
0
 

Author Comment

by:Plastikboot
ID: 21797613
Unfortunately not - it shows "Compressed Rich Text" as label and contains just hexadezimal data without spaces. I didn´t manage to get the contains decompressed yet - I tried Word, Excel and MS Access but no solution.
0
 
LVL 9

Expert Comment

by:Biffster007
ID: 21797639
Hmmmm....

There must be a tool out there that allows you to decompress into fields of some kind??

Can you re-export the data and save into another format??

MH
0
 

Author Comment

by:Plastikboot
ID: 21797685
Nope - I will try to access the SQL database of BCM and reformat the data there. So no solution yet.
0
 
LVL 9

Accepted Solution

by:
Biffster007 earned 1500 total points
ID: 21797757
That's the best plan...Reformat the BCM data, then export into another format compatible with the import wzard, then import into CRM.

MH
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question