One of the first tasks when building a Test Environment is the provision of suitable test data. Typically, test data is taken from, or based on, production data, with a full copy of production data the most common solution.
TestBench’s Data Extraction module vastly improves this process by enabling you to select the data you need and sample critical transactions to get a representative cross-section of data.
TestBench allows you to maintain the referential integrity of the data, even if the relationships are not explicitly defined in the database.
Being able to repeat quickly and easily all or part of a test with the same data is essential if you want to minimise the time taken by testing. Rather than performing lengthy backups and restores, TestBench’s Environment Protection (Data Reset) module enables you to set data checkpoints, either manually or automatically, at pertinent points in your test cycle. If you need to repeat part of a test at any time, you can simply roll the test data back to a previous checkpoint to set the data back to exactly how it was at that point in time.
This saves an immense amount of time by removing the need to restore data and repeat large chunks of testing just to get to the desired point. And, of course, you can undo all the changes to get back to where you started if you wish to run the complete test cycle again.
For those of you involved in developing and unit testing, TestBench also provides a data sandbox, call Program Reference Data Protection, which means you can always run unit tests with the same data without needing to create Checkpoints and issue Rollbacks. This also means that several developers can work with the same data without affecting each other’s work.