How to Maintain Application Data for Test Purposes

Previous Next

To maintain your application data:

1.In the USoft BenchMark toolbox, click Data.
The Operations On Application Database window appears.
2.Do one or more of the following, until you have repopulated your application tables with "fresh" data:

To recreate your application tables, click Create. Take care when using this option, as it will destroy any current data.

To remove the contents of your application tables, click Clear. Take care when using this option, as it will destroy your current data.

To completely drop your application tables from the database, click Drop. Take care when using this option, as it will destroy your current data.

To copy the contents of your application tables to a file. Check and, if necessary, change the name of the data file that will be used to store the exported data (unless you also specify a directory, this file will be stored in the working directory). Click Export.

To copy the contents of your application tables from a file. Check and, if necessary, change the name of the data file that will be used to read the imported data (unless you also specify a directory, this file will be looked for in the working directory). Click Import.

3.Click Close to close the window.

 

See Also

How to Automate the Maintenance of Test Data

How to Drop Undefined Tables and Sequences