Hi All,

I am about to try out the MS CRM CDF tool and am looking at loading about
829,626 records into the contact & lead tables -> not sure what the exact
split will be yet and about 256,787 records into the company table. How long
will it take to run all this through the CDF tool and get this loaded into
MS CRM and then how is the performance of MS CRM with this amount of data in
it?

I'll also be loading maybe another 100,000 records at a later date. Can I
use the CDF again for this import even though I'll have a lot of exsting
data I want left alone.

Thanks,
Jerry Rodgers

Dear Jerry,

About the time it will take to do the migration, I cannot give you a correct
answer. Probably nobody can since it depends on your system configuration a
lot.

I can guarantee that you can use the CDF tables several times to add data to
your crm system. For a client I have done a migration in 6 steps which goes
perfectly. Remember to clear the CDF tables before filling them up again.

With kind regards,

Ronald Lemmen
Avanade Netherlands

"Jerry Rodgers" wrote:

Thanks Ronald,

btw: I noticed a post from Matt Parks about a product called Scribe that may
be used for converstion too, does anyone on the list know what Scribe brings
to the table? Is it much better then the CDF?

Thanks,
Jerry




"Ronald Lemmen" <RonaldL@-REMOVETHIS-avanade.com> wrote in message
news:0F085E98-E6DC-40D6-8155-AA859D47902F@microsoft.com...

Jerry,

Importing data into CRM takes awhile. This will be true whether you use the CDF
or a product like Scribe. I have seen throughput with some custom processing we
developed to load data get as high as about 6-8 records/second. The CDF and/or
Scribe may be able to imporve on that a little depending on how they actually do
the processing. Bottom line though: the CRM API's are slow, so plan
accordingly.

We processed around 360,000 Accounts that each had a Primary contact created and
around 100,000 Annotations. Our best effort on this took close to 24 hours to
process. I highly recommend a dry run on the production hardware to get a feel
for the timing.

From what I've seen of Scribe, the big advantage it brings is it allows you to
map the data more easily into CRM. It hides some of the intricacies of the data
relationships a little for you whereas the CDF tables mirror the CRM tables and
you must ensure all the data is setup properly. Many have claimed to be able to
configure Scribe for import of data in a few hours.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Wed, 9 Feb 2005 08:25:56 -0800, "Jerry Rodgers" <jerryrodgers@comcast.net>
wrote:

Thanks Ronald,

btw: I noticed a post from Matt Parks about a product called Scribe that may
be used for converstion too, does anyone on the list know what Scribe brings
to the table? Is it much better then the CDF?

Thanks,
Jerry




"Ronald Lemmen" <RonaldL@-REMOVETHIS-avanade.com> wrote in message
news:0F085E98-E6DC-40D6-8155-AA859D47902F@microsoft.com...

note that some objects are slower to create than others. In particular
creating contacts through the sdk seems to be slow. In contrast i was able
to create accounts very quickly on 2 dual 3ghz xeons servers ie one for web
and one for sql

--
John O'Donnell
Microsoft CRM MVP
http://www.mscrmfaq.us


"Matt Parks" <mattp65@Yax_RemoveDashAndX_xhoo.com> wrote in message
news:nmpk01phs08f9bk34645367e3fegc6vgna@4ax.com...