Currently there is no way to remove specific entities from the database.
In need of this kind of process for those of us who have duplication in our databases.
I started working on this a few months ago but was unable to complete it because of distractions.
Development never built a process for removing an entity from the data warehouse because it was so complicated.
I am sure it is possible, but will require that all the dependencies are considered and the delete must happen from the TOP of the tree down. So first you must remove the leaves, the branches, the trunk, and the Entity itself is the root.
If you delete the Entity first (root) then you have all that wood and leaves left in the data warehouse...because it is disconnected from the entity it cannot be accessed nor easily deleted.
Is there a way of using the purge function to do this?
It has some code in it that makes it easy to sift thru many of the FACT tables. This could be repurposed to affect only rows that match on a GUID instead of "older than a specific date" and FACT tables are the "leaves" of the tree. There are many branches supporting those leaves that might get lost once the leaves are gone...
The solution must identify all the parts of the TREE before it starts deleting any of it...because of the dependencies.
The order you delete is important...(Tree top-down) might be too simplistic.
I am backing up my DB and App server and to upgrade to the lates version.
My question now is since there is no feature in the tool to delete entities, Whats the best way to clear all data in the DB instead of re-installing the DB itself.
I am planning to upgrade to the latest version first.
Hi Guys dupda03, limro02, Kip_Lamb
If I uninstalled CCC/DM, would it delete all the data I had on the DB? I am trying to avoid that by just truncating tables on the DB, but i dont know which tables to truncate.
Retrieving data ...