xinyii/dbdiff

mysql schema and data diff script tool

dbdiff

中文说明

• Create mysql schema and data diff script.
• Create markdown schema document.
• It is written in golang and can be built and used on any OS.

Install

1. Install golang latest. (https://golang.org/dl/)
2. Download src git clone https://github.com/jaksal/dbdiff.git
3. Goto src folder
4. go get && go build

Usage

Create schema diff script

dbdiff -diff_type=schema
  -source="uid:pwd@tcp(server_ip:port)/dbname"
  -target="uid:pwd@tcp(server_ip:port)/dbname"  
  -output=output.sql

Create data diff script ( The table to be compared must have the same schema to work properly. )

dbdiff -diff_type=data
  -source="uid:pwd@tcp(server_ip:port)/dbname" 
  -target="uid:pwd@tcp(server_ip:port)/dbname" 
  -output=output.sql

Create markdown document

dbdiff -diff_type=md
  -source="uid:pwd@tcp(server_ip:port)/dbname"
  -output=output.md

• The sample files are in the sample folder.
• output md file convert to pdf ==> ( https://github.com/jaksal/md2pdf )

Create sql script

dbdiff -diff_type=sql
  -source="uid:pwd@tcp(server_ip:port)/dbname"
  -output=output.sql

Extra option

  -include="test_"    // include db object name containing test_  
  -exclude="test_"    // exclude db object name containing test_  
  -output="[DATE]/output.sql"   // create today date folder
  -ignore_column=update_date  // ignore column in data diff mode

Bug

When comparing tables, if only the column name has been changed, it cannot be known with sql alone, so drop the column and add a new one. Please note that data will be lost during this process.