Overview

Little Bobby Diff Tool is a CLI tool to compare database schemas.

RDBMS support:

• MySQL
• Oracle
• PostgreSQL
• SQLite
• SQL Server

Items compared:

• Columns
• Column Privileges
• Indices
• Routines
• Routine Privileges
• Sequences
• Tables
• Table Constraints
• Table Privileges
• Triggers
• Usage Privileges
• User Defined Types
• User Define Type Privileges
• Views

Compilation

• Install Rust from https://www.rust-lang.org/

• Build Little Bobby Diff Tool:

  $ git clone git@github.com:oniony/lbdt.git
  $ cd lbdt
  $ cargo build
  

Usage

lbdt --left URL --right URL --schema SCHEMA [--schema SCHEMA ...]

For help:

lbdt --help

Examples

lbdt --left postgres://user:pass@localhost:5432/postgres \
     --right postgres://user:pass@localhost:85432/postgres \
     --schema public \
     --schema other \
     --ignore-column-ordinal \
     --ignore-whitespace

About

Little Bobby Diff Tool is written and maintained by Paul Ruane (paul.ruane@oniony.com) and is available at http://github.com/oniony/little-bobby-diff-tool/.

Written in Rust: http://rust-lang.org/

---

© Copyright 2024 Paul Ruane

Copying and distribution of this file, with or without modification, are permitted in any medium without royalty provided the copyright notice and this notice are preserved. This file is offered as-is, without any warranty.