Skip to content

A CLI tool for comparing database schemas

License

Notifications You must be signed in to change notification settings

oniony/little-bobby-diff-tool

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

91 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Little Bobby Diff Tool

Build Status

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

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 ([email protected]) 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.