Export Duplicate Detection Rules from one organization and import to another organization in CRM 2013

  • Article

Till now we did not have any inbuilt supported way of exporting the duplicate detection rules from one CRM organization to another in same or different deployment.  

Now, with latest release of CRM 2013 SDK Microsoft has provided a tool to achieve this and by which we will be able to export and import the duplicate detection rules using DataMigrationUtility.exe

We do not have any functionality in CRM in UI to export the duplicate detection rule or create a solution for it.  

  • Download the CRM 2013 SDK from following link :-  

             https://www.microsoft.com/en-in/download/details.aspx?id=40321 

  • Extract it and then go to tools folder  
  • Remember the duplicate detection rules have to be unpublished before the export. 
  • We will see a folder "CRM Configuration Migration". Open DataMIgrationUtility.exe tool.

 

Now follow below steps:  

  1. Disable all duplicate detection rules from the organization you would like to export the duplicate detection rules from.
  2. Next, open the tool you will see below screen:- 

 

 

  1. Click on Create Schema and then continue, it will give us a login page. Make sure  we check on "Display list of available organizations"

 

 

  

  1. Now based on your deployment select enter the details and login. Once it gets connected to the deployment we can select the organization we would like to export the rules from.

 

 

  

  1. Once we select an organization it will ask us to select the solution and the Entity .
  2. Then in drop down select  Entity as "DUPLICATE DETECTION RULES".  

 

 

 

  1. Next, select all and say add fields and add entity

 

 

 

  1. Similarly, add "Duplicate Rule Condition" as well  in SELECT Entity drop down and select all and say ADD Fields. Now, you should finally see like this:-

 

 

Then click on SAVE and then it asks you would you like to export the data--> Say YES and then you see below:-

 

 

  

  1. Save it in some location 

 

 

  

  1. And say EXPORT

 

   

  1. Next it will show you progress as follows :-

 

 

   

  1. It will notify once it is complete. This way we will get the schema file exported that we can import in any organization and get the duplicate detection rules.

 

 

  

IMPORT

Now, once we have the schema file we can import it to any other organization  :-  

Open tool again , select display all organization and login Select the organization we want to import duplicate rules in :-

 

 

 

 

 

 

 

 

 

Hope this helps all CRM users who were waiting for this feature in CRM for a long time!