Views:

Applies to Product – Dynamics 365 Commerce


What’s happening?
The customer needs to move a custom table containing 3 million records from the UAT environment to the Production environment.


Reason:
The customer attempted to use the Data Management Framework (DMF) and Power Automate for the data transfer, but these methods failed due to timeout issues. Direct SQL access for moving the data is not available.


Resolution:

  1. The customer should create a custom data entity.
  2. Use the Data Management Framework (DMF) with batch processing to move the data efficiently in smaller, manageable chunks.
  3. Direct SQL movement of specific tables is not supported by Microsoft; therefore, the recommended approach is to utilize the available tools in the Data Management Framework.