Search Results for "table compare"

sq is a command line tool that provides jq-style access to structured data sources: SQL databases, or document formats like CSV or Excel. sq executes jq-like queries, or database-native SQL. It can join across sources: join a CSV file to a Postgres table, or MySQL with Excel. sq outputs to a multitude of formats including JSON, Excel, CSV, HTML, Markdown and XML, and can insert query results directly to a SQL database. sq can also inspect sources to view metadata about the source structure (tables, columns, size). You can use sq diff to compare tables, or entire databases. sq has commands for common database operations to copy, truncate, and drop tables.

Percona Toolkit is a collection of battle-tested command-line tools for MySQL and MariaDB that help diagnose performance, verify integrity, and perform online maintenance safely. Utilities such as pt-query-digest analyze slow logs and packet captures to surface hotspots and regressions, while pt-online-schema-change applies ALTERs with minimal blocking by copying and swapping tables. Consistency tools like pt-table-checksum and pt-table-sync detect and reconcile replication drift across...

Command line tool, that compares Microsoft SQL Server table data between tables with the same columns in different databases. Original databases are not modified. Results are saved as SQL command file or displayed to the console. Multi threaded, open sourced project, that should fill empty niche for this kind of freeware software. As a command line application it can easily be used in batch processing.

A graphical and command line tool for comparing database tables. The comparison is displayed as html. This tool would likely be used to compare a test database table to a production database table.