locked
Issue with migrated data RRS feed

  • Question

  • I recently migrated goldmine data to crm using t-sql.
    when running a custom workflow to invite persons to
    an event the workflow stops because during the migration
    it seems that within the notes column from goldmine (i believe)
    null values were picked up. In crm often times you will
    see the chars � when deleting the chars manually the workflow
    will run and complete. Is there an easy way to remove these chars?

    Thanks
    Wednesday, January 13, 2010 11:47 AM

Answers

  • Cire,

    Raghu makes a good point.  Tinkering directly with CRM's SQL data is unwise for precisely this reason.  You don't always map things the way you should, and ultimately end up in an unsupported state with Microsoft regardless of whether or not "it worked".  Your best bet for restoring your good-standing with Microsoft, and your CRM database, is to redo your migration on a fresh deployment of CRM using the supported methods.  If necessary, there are also solutions from 3rd-party providers which ease the migration of data and simplify the process.

    Sans those recommendations, I think your inquiry is more of a SQL problem, than CRM, and would recommend redirecting it to an SQL-specific forum.
    Dave Berry
    • Marked as answer by Cire1507 Wednesday, January 13, 2010 8:38 PM
    Wednesday, January 13, 2010 7:30 PM
    Moderator

All replies

  • Hi ,

    You are not suppose to run any T-sql for data or schema on the MS CRM database, this is not supported.

    You have to these things using the MS CRM SDK or DMM or CRM front end.

    Thank You

    Raghu

    Wednesday, January 13, 2010 4:58 PM
  • Cire,

    Raghu makes a good point.  Tinkering directly with CRM's SQL data is unwise for precisely this reason.  You don't always map things the way you should, and ultimately end up in an unsupported state with Microsoft regardless of whether or not "it worked".  Your best bet for restoring your good-standing with Microsoft, and your CRM database, is to redo your migration on a fresh deployment of CRM using the supported methods.  If necessary, there are also solutions from 3rd-party providers which ease the migration of data and simplify the process.

    Sans those recommendations, I think your inquiry is more of a SQL problem, than CRM, and would recommend redirecting it to an SQL-specific forum.
    Dave Berry
    • Marked as answer by Cire1507 Wednesday, January 13, 2010 8:38 PM
    Wednesday, January 13, 2010 7:30 PM
    Moderator
  • It might be a little late for you Cire, but in case you do reconsider re-doing the migration or others are reading this thread, it is worth looking at the CRMMigrate product.  http://www.qgate.co.uk/crmmigrate/ This has been specifically developed to migrate data from Goldmine as well as Salesforce to Dynamincs CRM.  The data is put in via the web service SDK so preventing the sort of issues arsing that can be seen if using direct SQL.  A trial version to migrate a limited amount of data is available as a download.  The product is a Wizard driven tool, with mappings already done, and logic implemented to get round the gotchas of Dynamics CRM.

    Regards,
    Rowland.
    Thursday, January 14, 2010 11:10 AM