Data Compare Tool
The Data Compare Tool allows users to compare data in tables, views, or queries across databases or in the same database.
The options that can be selected on the data compare screen are the connection that to use to query the table or run the query, and whether to compare a table or a query. Once the options are selected, the compare tool will compare the data and display the differences similar to the unix diff tool.
Users can choose to do table to table compares, query to query compares, or table to query compares.