Saturday, November 21, 2020

Steps to follow when refresh dual-write integrated environments (FO and CE)


The D365 finance & operations app is linked to Common Data Services through dual-write in development or sandbox environments. You are required to refresh databases in D365 FO and CDS both from another production environment (dual-write integrated (linked) environments in the scenario)

Steps to follow:

  1. Before initial refresh, log on to target environment
  2. Go to Data management > Dual write and stop all jobs
  3. Refresh FO and CDS environments from the same integrated source environments
  4. Go to Data management > Dual write and Unlink environments
  5. Clean data from following tables in D365FO if data exists
    1. DualWriteProjectConfiguration - A sample URL would be like this to access tables from D365FO environment <Environemnt URL>/?mi=SysTableBrowser&prt=initial&limitednav=true&TableName=DualWriteProjectConfiguration&cmp=<CompanyId>
    2. DualWriteProjectFieldConfiguration- A sample URL would be like this to access tables from D365FO environment <Environemnt URL>/?mi=SysTableBrowser&prt=initial&limitednav=true&TableName=DualWriteProjectFieldConfiguration&cmp=<CompanyId>
  6. Clean data from DualWriteRunTimeConfiguration Table in Dataverse [Customer Engagement] - Click on little funnel on top right side of the CE environment to open table browser or Advance find and look for Dual write Runtime configuration table

  7. Link Environments
  8. Apply MS dual-write solutions and your custom solution if there is any
  9. Start jobs and no need for initial sync, both environments are already sync as were copied from another dual-write integrated source environments


  1. Do you need personal loan?
    Loan for your home improvements,
    Mortgage loan,
    Debt consolidation loan,
    Commercial loan,
    Education loan,
    Car loan,
    Loan for assets. Whatsapp +918929509036

  2. Thanks for this Faisal! This was helpful!


I will appreciate your comments !

Download large bacpac (sandbox database) to DEV environment much faster

As the LCS website gets slower and slower and the database backups get bigger and bigger.  Use AZCopy to download objects out of LCS asset l...