Hi,

Does anyone already used it ?

I'm trying to migrate cases/incidents, i've already imported data to
cdf_incident table using sql dts's and runned the migrationtool. I've
checked the log, and found no errors, but the data doesn't appears in the MS
CRM!!

Any suggestions ?
Thanks,
Hugo

No.
Used the default values: Use fast load and check constraints enabled

"Kevin @ 3NF" <Kevin@dallasdbas.com> wrote in message
news:eIvUnDdVDHA.1872@TK2MSFTNGP12.phx.gbl...

Yes, it is passing to the cdf tables, disabling those.

Now i'm having other problems, in the account_id, contact_id and customer_id
fields, because I don't know what values to put, to match existing instances
in the above entities.

How have you done ?

Thanks again,
Hugo

"Kevin @ 3NF" <Kevin@dallasdbas.com> wrote in message
news:eGDub1dVDHA.3924@tk2msftngp13.phx.gbl...

The one migration I did was from SalesForce.com raw data, which used a
case-sensitive, alpha-numeric ID field as its Primary Key. As you are well
aware, the CDF files require an Integer. The best way I found was to import
the data into a SQL Server db, create all of the relationships and set the
cascade update feature to update all related fields. I then wrote a script
to change the old alphanumeric key to an int. I logged each change in a new
table with the old and new keys in it for reference.

Painful, but effective.

There is also a search and replace utility to find every instance and
replace with something else, but it took forever on a relatively small
database (1200 accounts, 5000 contacts, etc.)

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm



"Hugo Fonseca" <hugo.fonseca@maeil.pt> wrote in message
news:Ogsv7EeVDHA.1704@TK2MSFTNGP11.phx.gbl...

Yes, i'm understading Kevin. You put everything in the cdf files, and
migrate everything once, with all the references made.

I'm loading just the entity 'Incidents'. The referenced Accounts, Contacts
and Customers are not filled in the cdf files. The instances i need are
already in the crm db and were created manually.

I believe my problem is not loading the cdf files, with integers as primary
keys, cause that's done. I think my problem is in the next step associating
the cdf integer keys with the keys existing in the ms crm db, in Accounts,
Contacts and Customers, while i execute the migration tool. In those
entities in ms crm the keys are unique identifiers not integers.

Do you have any other suggestion ?

Thanks again Kevin,
Hugo

"Kevin @ 3NF" <Kevin@dallasdbas.com> wrote in message
news:#CHE#9eVDHA.2004@TK2MSFTNGP11.phx.gbl...

Yep....glad you posted this, as I had no idea what to tell you. Seems like
an all or non effort when doing a migration...

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm



"Hugo Fonseca" <hugo.fonseca@maeil.pt> wrote in message
news:#lAPQXpVDHA.2260@TK2MSFTNGP09.phx.gbl...

Hi Hugo.

When populating cdf-tables with Foreign Keys, you can both provide the ID
and the "IDNAME". For example, you can put the string "Microsoft Inc." in
the "accountidname" field.

When you migrate the data, and the "Microsoft Inc." account is created in MS
CRM, the GUID from that account is returned to the Data Migration Framework.
When DMF then has to populate a relationship to that account, is uses the
GUID returned by MS CRM instead of the name!

You just have to make to, that data is migrated in the right order! First
Accounts, then Contacts, Then Cases/Incidents...

Best Regards.

Michael Randrup

"Hugo Fonseca" <hugo.fonseca@maeil.pt> wrote in message
news:%23lAPQXpVDHA.2260@TK2MSFTNGP09.phx.gbl...