Soft82.com » Windows » Developer Tools » Database » Database Applications » AnyDbTest 2.3.1

View screenshots

AnyDbTest Description

AnyDbTest is the first and only automated DB unit testing tool available using XML as test case

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.

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.

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.

The best way to see how AnyDbTest works is to read the Quickstart (10 minutes). Developers who already have experience with unit testing will find everything they need to know on the Cheat Sheet.

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.

AnyDbTest Limitations

4-week trial

AnyDbTest Download Button For Your Site

If you want to place a Download Button for AnyDbTest on your website just insert the following code:

If you want a Link to this page you can use one of the logos bellow:

AnyDbTest User Reviews

New Database Applications Software

MyDbExplorer Team Edition May 23, 2012 Connect to virtually any relational database backend				SQL Client May 23, 2012 Connect to your database with this tool
Nevron SSRS Vision May 22, 2012 Professional Data Visualization Component Suite for SSRS				DbWrench May 18, 2012 Our goal with DbWrench is to make database design cycles quicker and easier
Sfairadora May 17, 2012 Flexible tool for small databases with functions of spreadsheet and text output				Reportizer May 17, 2012 Database reporting tool
dbForge Schema Compare for Oracle May 16, 2012 Compare and synchronize Oracle databases with ease				DTM DB Stress Professional May 16, 2012 A utility for stress testing the server parts of information systems and applications
LinqConnect May 16, 2012 A fast and easy to use ORM solution				SQL Vehicle Database Download + ASP.Net May 16, 2012 Get the 1904-2013 vehicle data in MSSQL and MySQL formats
Association Manager May 15, 2012 ALL-IN-ONE, Easy to Use and Membership and Event Management Solution for Associations				DataCleaner May 14, 2012 An Open Source application for analyzing, profiling, transforming and cleansing data
SQL 2 Excel May 14, 2012 Import SQL queries in Excel tables				dbForge Schema Compare for MySQL May 14, 2012 Tool to compare and synchronize structures of MySQL databases
Database .NET May 14, 2012 A simple, uniform and intuitive database management tool for multiple databases				ERD Concepts May 14, 2012 Database software for professionals
dbForge Data Studio for SQL Server May 14, 2012 Chief query tool for SQL Server data analysts and developers				ETL-Tools QlikView Connector May 10, 2012 An ideal tool for customers who are working with complex and bad quality data
Log Table Viewer May 10, 2012 Provides a unified logging interface for your SQL code				DbVisualizer Personal May 10, 2012 Helps you with both the development and maintenance of your databases

Last 7 Days Most Downloaded Database Applications Products

DB Load Generator 34 downloads The easy way to test your database setup, server performance or sql query effectiveness				TOra 19 downloads Database management GUI that supports accessing most of the common database platforms
SQLDumper 17 downloads SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT				Firebird 16 downloads Firebird is a relational database offering many ANSI SQL-92 features
EMS SQL Manager for MySQL 13 downloads State-of-the-art GUI tool for MySQL Server administration and development				NGen NHibernate Code Generator 12 downloads A Mapping generator for NHibernate via FluentNHibernate and NHibernate.Burrows
DbVisualizer Personal 11 downloads Helps you with both the development and maintenance of your databases				SQLite3 9 downloads A command-line access program for SQLite databases
Pdxrbld 8 downloads Utility for checking and repairing Paradox tables				EMS SQL Manager for PostgreSQL 8 downloads Powerful graphical tool for PostgreSQL DB Server administration and development

All Time Most Downloaded Database Applications Products

DB Load Generator 3,344 downloads The easy way to test your database setup, server performance or sql query effectiveness				TOra 802 downloads Database management GUI that supports accessing most of the common database platforms
SQLDumper 6,389 downloads SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT				Firebird 3,331 downloads Firebird is a relational database offering many ANSI SQL-92 features
EMS SQL Manager for MySQL 2,065 downloads State-of-the-art GUI tool for MySQL Server administration and development				NGen NHibernate Code Generator 492 downloads A Mapping generator for NHibernate via FluentNHibernate and NHibernate.Burrows
DbVisualizer Personal 1,072 downloads Helps you with both the development and maintenance of your databases				SQLite3 256 downloads A command-line access program for SQLite databases
Pdxrbld 128 downloads Utility for checking and repairing Paradox tables				EMS SQL Manager for PostgreSQL 1,478 downloads Powerful graphical tool for PostgreSQL DB Server administration and development