Reduce the size of the channel database after synchronization

  • Article

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

If your organization has large channel databases, you may want to consider installing KB 3208173, and then configuring your environment to automatically remove unwanted master data from your database after each synchronization. You can customize the data that is removed.

Install KB 3208173

To use this feature, you must download 3208173 from Dynamics Lifecycle Services and install it on the AOS, Channel database, and Async client. For instructions, see Apply updates and hotfixes.

Configure removal of unwanted data after synchronization

  1. Open the Retail schedule parameters form (Retail > Setup> Retail schedule parameters).

  2. Select Remove unneeded master data from channel database.

  3. Run Commerce data exchange schedule 1110 to sync this change to the channel database.

    After the configuration has been synchronized, the Async client will remove unwanted master data from the channel database.

Customize which data is removed

You can customize which data is removed by modifying the crt.STRIPMASTERDATA stored procedure in the channel database.