Bring Your Own Database(BYOD) in D365FO - Dropping Data entity

Views (1108)

Chaitanya Golla

17,225

Like(0)

Report

Hi,

In this post, we will discuss the process of dropping the published entity i.e. staging table gets deleted from the target Azure database. For demo purpose, I have selected vendor groups entity.

Step 1: Navigate to the entity publish page(Path: Data Management workspace > Configure entity export to database tile > Publish button) and select Vendor groups entity.

Step 2: Click on Drop Entity option on the action pane and a message appears stating "Drop job has been scheduled".Close the message.

Step 3: Refresh the page and mark the checkbox "Show published only" to see that the vendor groups entity disappeared from the published list(as shown in the below screenshot).

Step 4: We need to confirm that the corresponding staging table(vendVendGroupStaging) gets deleted from the target Azure database. So, verified the tables node(through SSMS) of the target database and staging table of Vendor group entity is deleted.