Tech Support > Microsoft Windows > Windows CRM > migrating a Knowledge Base into CRM
migrating a Knowledge Base into CRM
Posted by Rick Delorme on August 21st, 2003


Hi group,

I am attempting to migrate our custom KB into the crm. KB is not supported
in migration toolkit, so I am attempting to use DTS directly into CRM. I am
able to get all the record in by defaulting the user to admin, statecode to
published, etc, etc. I changed the column of the KBbase table so that the
pkey has a default of newid() just to get primary keys in there. The only
field that I am unsure about is the securityDescriptor. So, to fake the
securityDescriptor, I created an article through the crm ui, published it,
then copied the securityDescriptor for that one into all the other ones.

All the knowledge base articles flowed in nicely via the DTS, however, I
cannot see them in the UI. Before I go ahead and right software to use the
SDK to do this, can anyone suggest anything that I might be missing to make
this work with DTS as this is the faster solution.

TIA.

Rick.



Similar Posts