locked
Reassign all CRM records in SQL RRS feed

  • Question

  • Hi,

    Is there any way to reassign all CRM records to a single Admin Account through SQL query? Any suggestion is appreciated.


    Dhivya Sivasankkar

    Thursday, July 17, 2014 6:16 PM

Answers

  • Could you just do an Export for Reimport of the affected records? Change the assigned to column to the admin user you want everything assigned to. Should be fairly quick.

    • Marked as answer by DhivyaSiva Monday, July 21, 2014 4:08 PM
    Monday, July 21, 2014 2:31 PM

All replies

  • Hi,
    update CRM records directly by SQL query is not supported and can lead to issues in your environment.

    You need to reassign them using CRM Web services.


    My blog: www.crmanswers.net - Rockstar 365 Profile

    Thursday, July 17, 2014 7:04 PM
  • Thanks. We are trying to import PROD CRM DB to Dev and finding issues in the Org import as not all PROD users are in DEV domain. If there is a SQL script that would reassign all the CRM records to Admin account, I can run the SQL script against the backup of PROD DB and we can delete all the other users and import Org to DEV would run without any issues. Any thought on this approach?

    Dhivya Sivasankkar

    Thursday, July 17, 2014 7:09 PM
  • Once you import the org into your Dev environment, there is a step asked you to map the user, you can simply map all prod users to one user, then it will assign all record to this mapped user.

    • Proposed as answer by Ju_li3nMVP Friday, July 18, 2014 9:24 AM
    Friday, July 18, 2014 2:51 AM
  • In the step to map the users, there is no way we can map all the prod users to a single admin user. It gives the error - "You cannot map more than one Microsoft Dynamics CRM user to the same account. You must manually specify different account mappings for these users." Please Advise.


    Dhivya Sivasankkar

    Friday, July 18, 2014 12:55 PM
  • Any suggestions anyone?

    Dhivya Sivasankkar

    Monday, July 21, 2014 1:28 PM
  • Could you just do an Export for Reimport of the affected records? Change the assigned to column to the admin user you want everything assigned to. Should be fairly quick.

    • Marked as answer by DhivyaSiva Monday, July 21, 2014 4:08 PM
    Monday, July 21, 2014 2:31 PM
  • Thanks. That's what we are planning to do.

    Dhivya Sivasankkar

    Monday, July 21, 2014 4:09 PM