AnyDbTest 2.3 (Windows)

Overview:

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. 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-shop 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; 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.

(Is this item miscategorized? Does it need more tags? Let us know.)