clear database information

Questions around Server admin, DB admin, email, printers, scanners etc related to Proclaim.
Post Reply
rob1
Posts: 3
Joined: Tue Dec 20, 2016 10:41 am

clear database information

Post by rob1 » Wed Sep 25, 2019 6:32 pm

Hi,

I was wondering if anyone knew of a quick and easy way to clear out data from a test database?

I assume one method would be to connect to the database and truncate some tables, or another being to run mass case deletion. I was hoping there would be a better way of doing this?

Enigma
Posts: 54
Joined: Mon Mar 04, 2019 1:01 pm
Has thanked: 4 times
Been thanked: 6 times

Re: clear database information

Post by Enigma » Thu Sep 26, 2019 8:52 am

Hi Rob,

What data are you referring to?

If it is cases, mass case deletion is probably your best bet.

If it is data on a file, a large PUT ( "" , {XYZ.ABC} ) maths item :P

Anything screens you can do on mass.

For other aspects of the system, you are probably looking at manually removing individual items.

I would suggest have a barebones 'Testing' case type that you can Go Live out and have that stored somewhere. Each time you want to throw the reset switch, delete the current one and Go Live the template back in.

Other than that I'm not too sure.

Post Reply