Microsoft CRM 4.0 data migration?

Dynamics CRM 4.0 provides built in tool called Dynamics CRM 4.0 Data Migration Manager to help developers migrate data from previous database into Dynamics CRM 4.0 database. I haven't used it extensively, but as far as I know, the previous data needs to be exported into a "standard" excel format provided by CRM 4.0 Data Migration Manager (DMM) You can refer to below references : http://blogs.msdn.com/crm/archive/2008/01/04/microsoft-dynamics-crm-4-0-data-migration-manager-with-john-o-donnell.aspx http://www.microsoft.com/downloads/details.aspx?FamilyID=6766880a-da8f-4336-a278-9a5367eb79ca&displaylang=en There is also 3rd party solutions called Scribe http://www.scribesoft.com that will help you migrate to Dynamics CRM 4.0 database.

Dynamics CRM 4.0 provides built in tool called Dynamics CRM 4.0 Data Migration Manager to help developers migrate data from previous database into Dynamics CRM 4.0 database. I haven't used it extensively, but as far as I know, the previous data needs to be exported into a "standard" excel format provided by CRM 4.0 Data Migration Manager (DMM). You can refer to below references : http://blogs.msdn.com/crm/archive/2008/01/04/microsoft-dynamics-crm-4-0-data-migration-manager-with-john-o-donnell.aspx http://www.microsoft.com/downloads/details.aspx?FamilyID=6766880a-da8f-4336-a278-9a5367eb79ca&displaylang=en There is also 3rd party solutions called Scribe http://www.scribesoft.com/ that will help you migrate to Dynamics CRM 4.0 database.

Yes, this tool is good for importing, but I have to get the data out of the mdb first, which is what I meant about the intermediate format. I'm thinking I just write SQL queries to extract all of the disparate columns into clean tables, export them into a csv, then use the Data Migration Manager (DMM) to import into CRM. I can't think of any other way... – Shane Aug 18 '09 at 6:01 If you are using DMM, then you can try if there's any export functionality at the MS Access to the Excel format directly.

Alternative way, maybe there is a tool to "convert" from Ms Access format to SQL Server format. – hadi teo Aug 19 '09 at 5:35.

I've had success just using the mscrm api in these kinds of cases. You can write a . Net app which use odbc to connect to your mdb then use the mscrm api to create the entities you need on that end.

Anyway you cut it - it's not too pretty but you can get the job done. Good luck. Ms CRM Service Reference.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.