Microsoft Dynamics CRM (Archived)

Configuration Migration tool limitation

(0) Share

Report

Posted on by yify

1,023

Hi,

Just wondering what would be the limitation of the Configuration Migration tool for importing the number of records?

Would it be possible to import the records more than a million? Let me know if anyone have tried more than that amount of records

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

Hi James, I don't think it will restrict you to import more than a million record but it would take forever. This tool is designed for the importing the config records which are not related to other entity records (which normal doesn't have too many records).

I would suggest to go for excel import as this would be comparatively more quicker. I remember I used this tool to migrate the regions data which was around 5K, it took more than an hour to get all the records in the system :)

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

The other option is to use kingswaysoft to migrate the data-

www.youtube.com/watch

Hope this helps.

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (1)

Report

Hi James,

For this amount of records, I would suggest going with SSIS and Kingswaysoft.

It seems you are also working with CRM On-Premise, which will make querying the data that you are looking to import a little easier (if your datasource is OLEDB for example).

Hope this helps.

Was this reply helpful? Yes No
antc 2,909 on at

Like (0)

Report

Another vote for Kingswaysoft and SSIS.

Also remember you can get their premium tools if using within VS which allows deduping, merging, transforms and all sorts of other wonderful things. I use a mix of excel and SQL but prefer SQL as excel struggles with some field types.

They also have a DTS package that gives an excellent starting point for a CRM to CRM migration.

Was this reply helpful? Yes No
faisalimran 82 on at

Like (0)

Report

If you will use built-in tool then you have to divide your file into smaller size and it will take lot of time.

My suggestion: You should use kingswaysoft SSIS Integration Toolkit or Scribe Insight

Was this reply helpful? Yes No
Suggested answer

Rob Boyers 260 on at

Like (0)

Report

Personal experience with this is if you try to ship more than about 100k rows it either times out at the pre-processing stage or throws an error. There's obviously a bunch of variables to consider such as entity complexity though. Another decent option if you have an Azure subscription is to use Azure Data Factory. Using a simple 'copy data' activity within my pipeline, I'm getting about 100k rows migrated in 7 minutes. This is a very simple entity however.

Was this reply helpful? Yes No