Testing Tool for SQL Server -- Data Analysis and Validation

[wawalla]

Does anyone know of an automated testing tool for running data analysis and validation. The company that I work for is a Search Engine Marketing company, and we provide a software that interacts and pulls in data from Search Engines for Reporting to Clients.

We really need an Automated Program that can test Data - we use SQL Server 2005.

Any Suggestions...thanks in advance. We really need some help here.

Preferably a program that is good for beginners. I am new to both SQL and QA.

[Ramprasad G]

Are you looking for which sort of data testing ??

Are you going to test the data validation/to analyze the duplication of data in sql server ?

[indu19]

hi,

i think these tools are very useful to you..

KayRa
Environment : Linux
Category : Monitoring,Test Automation
Subject : Monitoring, Test automation, Web, Security testing,
Description : KayRa is a Web Application Security Auditing Tool designed to test the security of websites by analyzing web pages. Some of the tests include: SQL Injection, XSS, Form behaviour with bad data. All tests carried out will be based on the OWASP guide.


FlexTracer
Category : Test Automation,Monitoring
Subject : sql server tracer, oracle tracer, mysql tracer, interbase tracer, odbc tracer, file monito,r registry monitor,
Description : FlexTracer is a useful and powerful utility that can be used for tracing various application calls - from Windows API functions to Oracle Call Interface. FlexTracer creates history log containing names of all invoked functions, their parameters, results and execution time. FlexTracer is flexible. Unlike other tools, which can show you in most cases only memory dumps and register values, FlexTracer is highly customizable and makes it possible to define what you want to trace and how you want to trace it. Its main IntelliTrace feature enables you e.g. to get the SQL-statement instead of its handle used in function call or to see the readable result codes like OCI_SUCCESS instead if its numeric value. One of the main purposes of FlexTracer is to trace database SQL-queries. FlexTracer supports many RDBMS, such as Oracle, MS SQL Server, Interbase, MySQL, ODBC, ADO. With this tool you don't need to have the administrator privileges on your database server or ask your database administrator for help or to browse long trace logs every time when you want to know what your application does. Windows registry and file routines are also supported.

you can download these tools from Here

All the best...