SQLCompyre

SQLCompyre is a simple Python package that allows you to find and explore the differences between SQL tables, schemas, and entire databases. It provides both a Python interface and a CLI, allowing it to be used for both ad-hoc comparisons as well as in-depth analyses.

SQLCompyre is designed to be dialect-agnostic and should, thus, work with most database systems out-of-the-box. At the moment, is has been explicitly tested on the following systems:

• SQLite

• Microsoft SQL Server

Contents

• Installation
• Getting Started
  • Prerequisites
  • Creating a TableComparison Object
  • Generating a Report
  • Accessing Comparison Metrics
  • Using Query Results
• Development

API Reference

compare_tables	Compare two tables in the database.
compare_schemas	Compare all tables from two schemas in the database.
inspect_table	Inspect a table in the database.

Analyses

QueryInspection	Inspect the results of a SQL query.
TableComparison	Compare the content of two SQL database tables.
SchemaComparison	Compare the table metadata from two different SQL database schemas.

Results

Counts	Investigate the counts of database objects.
Names	Investigate the names of database objects.
RowMatches	Investigate (un-)matched rows between database tables.
ColumnMatches	Investigate column value changes between database tables.

Report

Report	Summary of the comparison of two SQL database objects.
formatters	Formatters for rendering reports.
writers	Writers for outputting sets of reports to a destination.