There will be times when you will be testing EAS setup and rules for your project and will want to clear all the subject data out of the system while retaining the current configuration. Rather than truncating individual tables, you can use SUIT to clear out the database.
Obligatory Warning
This command will clear out all subject data in your system, with no "Are you sure?" warning. Unless you only have a handful of identities that you can submit again, it would be in your best interest to back up the RELRES database before executing.
The SUIT command is located in [EAS install directory]\suit\sql. The command to delete identity data is:
suit -t [dbms] -s [server] -d [database] -u [username] -p [password] [RELRES schema] internal-clean -auto
where [dbms] is one of the following:
- oracle
- mssql2000
- mssql2005
- db2
- zdb2
and [RELRES schema] is either RELRES.NO_HIST or RELRES, depending on your initial installation.
The rest of the parameters should be self-explanatory. You can see the full set of parameters by running SUIT with no parameters.
No comments:
Post a Comment