|
|
|
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 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.
All xUnit test frameworks are imperative style testing tools such as DbUnit, NUnit. To great extent, all xUnit tools are programming frameworks, rather than plug and play test tools. Using those xUnit tools for database, you will have to handle many complicated programming components
and APIs. They are suitable for application developers, but are not the right choice for DBA and DB developers. DBA and DB developers need one tool which has low learning curve.
On the contrary, AnyDbTest is declarative style testing tool. What we do is to express what we want to test, rather than how to test.
We only need to configure an XML test file to tell AnyDbTest what we want to test. Rather than painstakingly writing test code for xUnit-like test framework. So AnyDbTest is the right choice for DBA or DB developers.
AnyDbTest also offers a visual dashboard. Success or failure of test is automatically computed and presented to you via an easy-to-understand red/green light display.
For any serious database development, one important and hard thing is you need large amount of test data to verify your system. Not worry, you can not only perform data pump in test
case initialization from any reference database, but also you can validate any query result set with any reference database.
|
|
|
|
