Performing CRUD operations between different CRM environments
In this blog, we are going to discuss how to perform CRUD operations between CRM environments. As you all might be aware, there are already existing ways to do data migrations, such as Data Import , Kingswaysoft SSIS Package , using programs, and so on. Here we are going to perform data migration between CRM environments in a different way to import data with the same record identifier and then we are going to perform read, update, and delete operations on imported data. Prerequisite: You must have an understanding of the SQL queries. So, Let's Start. 1. Open SQL 4 CDS in XrmToolBox. 2. Add connection of source and target environment. In this example target is RND and source is TEST . 3. Write a query to perform operation and execute it. CREATE: Inserting records from source environment to target environment. Here we are inserting only two columns, activityid : record identifier and subject , with a pretext of ' Imported Task: '. So, you can add the columns you want a