Skip to content

Home

Jump to bottom
David Elish edited this page Nov 8, 2016 · 3 revisions

Welcome to the SQL Results Compare wiki!

SQL Results Compare is a Microsoft Windows based command-line application that leverages the Microsoft SQL Server database engine, Microsoft SQL Server bcp (bulk copy program utility), and a choice of diff/compare tools to graphically display the differences in output of pairs of SQL queries. It is intended to be used as part of a testing framework, by storing pairs of queries and their target server information, to execute batches of queries, and return their differences with a single command-line call.

Highlights

  1. Execute queries against any database server platform for which a Microsoft SQL Server Linked Server can be created.
  2. Execute SQL statements native to the target database server platform.
  3. Execute as few or as many comparisons with a single call by grouping them into Query Categories and Query Subcategories.
  4. Use any SQL Server instance, local or remote (with the necessary permissions), as the "query broker".

Clone this wiki locally