AnyDbTest is an automated DB unit testing tool designed for DBA and developers. It supports popular databases, including Oracle, SQL Server, and MySQL, and uses Xml as test case input.
AnyDbTest has been designed specifically for DBA/DB developers and supports all popular database systems, including Oracle, SQL Server, and MySQL, among others. The tool also has the added advantage of validating replication, ETL, DTS & SSIS result, making it an all-around testing solution.
One of the standout features of AnyDbTest is its ability to visually compare data of two SQL queries between two databases, highlighting differences on the screen. The tool also boasts of built-in data pump and record-set comparison functions, offering a one-stop service for ETL and validation.
In terms of test case development, AnyDbTest supports many kinds of assertion, including StrictEqual, SetEqual, IsSupersetOf, Overlaps, and RecordCountEqual, among others. Excel spreadsheets or Xml can also be used as the source of data for tests. Furthermore, the tool supports Sandbox test model, which means that all database operations will be rolled back if the test is done in sandbox, undoing any changes.
Lastly, AnyDbTest offers unique cross-different-type-database testing, which means that target and reference result set can come from two databases, even if one is SQL Server and the other is Oracle. In summary, AnyDbTest is a must-have testing tool for any database administration or development team.
Version 2.4.5: Optimize UI, and fix some defects
Version 2.3: Optimize UI, and fix some defects
Version 2.1: Support MySQL 5