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.

AnyDbTest keywords: anydbtest, unittest, database unittest, db unittest, database automatic test, unit test, database unit test, db unit test, db automatic test