How to delete complete repository data

[Former Member]

Hi experts!

I want to know is there a smart way of deleting entire repository data at one go.

I mean i dont want to manually select thousands of records.

Is there another way to achieve this?

Thanks,

Ravi

[Former Member · Accepted solution]

if it is the main table items :

you can make use of the MDM webservices (CRUD) and delete all the items programatically.

make sure you check that there is no read lock on items and that they are not checked out

on the LUT/QLUT/Hieracrchy/Taxonomy : you have to make sure the dependant/referenced items are first deleted before attempting to delete them

hope this helps.

thanks

-Adrivit

[Former Member]

Hi Ravi,

Is there another way to achieve this?

Yes with MDM 7.1, you can also take archive of repository without records. Thus you just need to do unarchived and load this repository. Now once you login into MDM Data Manager, you will have 0 records.

Regards,

Mandeep Saini

[former_member205403]

Hi,

I agree with Mandeep. Repository Schema only Archive is the best way to get rid of all data in one shot.

You can create create archive file from your existing repository. Now unarchive the repository using this .a2a file overwriting your existing repository.

Best Regards,

SHiv