![[Level:6]](http://www.vietnamesetestingboard.org/zbxe/modules/point/icons/default/6.gif "Point:1190point (28%), Level:6/30"){kind=icon}
TaqtislasAs a fundamental technique, comparing expected results against actual results is crucial when deciding if a test is to pass or fail. As such data comparison becomes a key technique in any software testers list of skills. Comparing large amounts of data held in databases can be less than straight forward though. SQL Delta simplifies this process immensely and makes checking data between separate databases a breeze.
SQL Delta allows you to compare different databases so that you can identify differences between large amounts of data within seconds. You no longer need to manually export databases and compare in text editors (or text comparison tools). You remove the uncertainty and inaccuracies associated with eye balling data and drastically reduce the amount of time taken to spot problems.
Using SQL Delta to compare both schemas and data between two Microsoft SQL databases will help you identify differences between tables, views, stored procedures and other database objects. As part of application upgrade testing this tool is invaluable in helping you see the differences between a clean install of a database and a version of a database that has been upgraded (helping you ensure that the schema for an upgraded database is identical to a cleanly installed database).
Implementing SQL Delta not only increases the accuracy of any database comparison efforts but easily saves significant amounts of time and effort. In addition to this SQL Delta also:
- Compare different database objects - Compare database structure and all scheme objects between two databases, with simple to interpret difference displays.
- Perform comparisons offline - Create snapshots of database schemas in order to perform comparisons offline and create synchronization scripts.
- Create difference reports - Produce extensive reports detailing entire database schemas in addition to comprehensive comparison reports.
- Clear highlighting - See the differences between inline data for rows in the same context with same data. This is essential in helping see why and where data differences occur.
Compares databases in Microsoft SQL Server 7, 2000, 2005 and 2008 (limited support provided for SQL Server 2008). System requirements; Microsoft Windows 2000, XP, Vista or higher, 50mb disk space, 256mb RAM, Microsoft SQL Server 7 or 2000, 2005 and MDAC 2.6 or higher (you can download from Microsoft for free if needed)
