We are using the data migration framework to migrate into a fresh CRM 1.0
installation. We are at the step where we run the CDFMigration Tool. It
runs and completes with no errors. It only migrates contacts, no accounts,
incidents, etc.
Steps
1. A clean restore of the cdf_mscrm, and CRM databases(which were backed up
right after we finished cleaning the data, before we started to migrate)
2. The cdf_"entity"_info table for account, activity, annotation, contact,
incident were empty: followed TechKBArticle #31094 from MSBTechKnowledge
which said to run:
Declare @Id As int
Declare c_Cursor Cursor For
Select AccountId From cdf_Account
For Read Only
Open c_Cursor
Fetch c_Cursor into @Id
While (@@fetch_status = 0)
Begin
Insert Into cdf_Account_info (AccountId) Values (@Id)
Fetch Next From c_Cursor Into @Id
End
Close c_Cursor
Deallocate c_Cursor
Ran for all tables mentioned earlier, substituing correct ID and table
names. Successfully populated the info tables.
3. Ran the following stored procedures:
p_cdf_setTestBatchCount <allentities>, 0 *don't worry, we list each
entity.
p_cdf_clearAllTestBatchCounts
p_cdf_clearAllDestinationIds
p_cdf_reset
which all run in Query Analyzer without problems.
4. We then ran the CDFMigration Tool. This ran without errors. Our log
shows no errors but the contact table was the only table successfully
migrated.
Would appreciate any help.
Thanks,
Jimmy Crews