SQLDiffer is a comparison tool used to visually display selected data for easy observation of the differences. The data used in the comparisons can be obtained from a wide range of databases. Any database with an ODBC interface is supported by SQLDiffer.
Data is retrieved from the database using Structured Query Language (SQL). For users, unfamiliar with creating complex SQL, SQLDiffer contains a SQL Query Builder making creation of SQL statements quick and simple.
Data is compared visually under the comparison tab in SQLDiffer. The results are displayed side by side with visual highlighting for easy identification of the differences. SQLDiffer also contains options to show all the rows in the grid or just the rows that contain differences. Grouping of the data is also a useful SQLDiffer feature eg When looking at two sets of orders adding a grouping to the results on "customers name" gives easier assimilation of the data.
Created comparisons can be saved and rerun at a later stage to show updated data from the data sources.