Enables to accomplish both of these tasks and has many more function-rich.
BSEditor: SQL DB Validator enables you to accomplish both of these tasks and has many more function-rich features.
SQL DB Validator tests the content of a database Extract against its original data store using the specific SQL syntax for each of the data sources:
路 MS-SQL
路 MySQL
路 DB2
路 Oracle
路 Teradat
路 MS-Access
路 Exce
路 and others
Access to all of these databases is obtained using OLEDB and ODBC drivers.
Tests can be contained in a single file and each test can be configured to Connect to different data sources. This allows the user to:
Compare the content of a Excel report populated from a cube, against the original content in the database.
Using MDX, compare The Cube content directly with the original database
Special features of SQL DB Validator are:
Tests can compare data content, date content, or row counts.
Concurrent test Execution ensures tests will run in the shortest possible time. They may also be run sequentially.
A command line interface allows for integration of the software testing tool with any current test automation system.
A customizable Syntax Highlighting Editor, which aids in query design, is integrated into the tool. you can free download SQL DB Validator 1.2 now.