AnyDbTest^®2.2.4

AnyDbTest is the first and only 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 replication, ETL, DTS & SSIS results. You can compare data of two SQL queries between two databases visually to see differences highlighted on the screen. You can even get the one-stop service for ETL and validation via built-in data pump and record-set comparison functions.

According to data presented by a number of organizations, early testing can provide a cost improvement of as much as 100 times over the practice of relying on system testing that occurs after integration. (Reference1, Reference2).

As one best practice of early testing, unit testing is a popular concept in application development. And in application developement community, there are many unit testing tools for developers, such as jUnit, NUnit, CppUnit etc.

But the database community has not yet embraced the advantages and strategies of this approach. Most database developers have little or no concept of unit testing and there are few, if any tools to support them. (Refer to this article from InfoQ). DBA/ DB developers had a long test feedback loop originated from application developers/testers, they were not really benefiting from unit testing.

Now this problem is history. AnyDbTest has filled this gap with offerings of so many cool features. And it offers some killer highlights such as Sandbox test model and cross-different-type-database test. All of these help it to exceed other existing tools.

AnyDbTest is a good solution because it enabled DBA and DB developers to write test cases by configuring an XML file. You will not need to program at all. Obviously it is easier than in TSQL/PL-SQL based and Java/.Net based unit testing libraries. Plus, the verifying process will not be tedious and error-prone again. With AnyDbTest, you will greatly reduce the amount of errors in your database code/script.

Features specific to AnyDbTest:

• Writes test case with XML, rather than Java/C++/C#/VB test case code


• Many kinds of standard assertion supported, such as StrictEqual, SetEqual, IsSupersetOf, Overlaps, 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 if one is SQL Server, another is Oracle.