AnyDbTest 2.3

Download Now

AnyDbTest is declarative style testing tool. We need not to program any more. What we do is to express what we want to test, rather than how to test. We only need to write an Xml test configure file to tell AnyDbTest what we want to test. Rather than painstakingly writing test code for xUnit test framework. So AnyDbTest is the right choice for DBA or DB developers.

AnyDbTest is the first automated DB unit testing tool available using Xml as test case. AnyDbTest is just designed for DBA/DB developers. It supports all kinds of popular database, such as Oracle, SQL Server, and MySQL etc.

AnyDbTest can also be used to validate the replication, ETL, DTS & SSIS result. You can compare data of two SQL queries between two databases visually to see differences highlighted on the screen. Even you can get the one-stop service for ETL and validation via built-in data pump and record-set comparison functions.

Features specific to AnyDbTest:

*Writing test case with Xml, rather than Java/C++/C#/VB test case code.

*Many kinds of assertion supported, such as StrictEqual, SetEqual, IsSupersetOf, Overlaps, and RecordCountEqual etc.

*Allows using Excel spreadsheet/Xml as the source of the data for the tests.

*Supports Sandbox test model, if test will be done in sandbox, all database operations will be rolled back meaning any changes will be undone.

*Unique cross-different-type-database testing, which means target and reference result set can come from two databases, even one is SQL Server, another is Oracle.

Link to AnyDbTest download page: