Wednesday, October 7, 2020

Replicate Data to Azure SQL Database - Part 2

Previous Post - Validate Data Export Profile

In this part we will replicate data to Azure SQL Database using Data Export Service profile that we have validated in Part 1 - Validate Data Export Profile.

We will also see how Data Export Service makes transactional data (frequently updated data) easily replicates to Azure SQL Database.

1. Assuming Data Export Profile validation is successful in previous part - Validate Data Export Profile(LINK), click Next button and select entities whose data we want to replicate.

Note: if the required entity is not coming in the search list then you need to enable Change Tracking in the Entity properties.

2. Select the Relationship, if exist.

3. Select Next and Activate the Data Export Profile.

For Example, we use 2 entities i.e. ics_child and ics_subchild.

4. Refresh the Data Export Profile after some time.

Whooaaaaaa! We have successfully replicated the data of 2 entities i.e. Child and Sub Child to the Azure SQL Database.

5. Let’s go to the Server Explorer and see our data.

Here we can see our both Entities that we have selected for replication in Step 1.

6. We will see the records (rows) in SQL DB.

So here they are. This is how Data Export Service Works.

We don’t have to be worry about the transactional data (frequently created or modified). The replication of data will occur at the same time when there will be any record modified or new record is created in the Common Data Service.

We can also see the analytical figure of our data in Azure Portal by going to the Database (DataExportServiceDB).