Check the difference of MySQL schema (CREATE TABLE)
Project description
sqldiffer
Check the difference of MySQL schema (CREATE TABLE)
Feature
- Check the difference of MySQL schema
- Compare CREATE TABLE
- Choose whether to ignore AUTO_INCREMENT and CHARSET
- Output HTML
- Save the difference for each table in HTML (Click here for sample)
Installation
pip install sqldiffer
Usage
sqldiffer -h
usage: sqldiffer [-h] --server1 SERVER1 --server2 SERVER2 [-o OUTPUT_DIR] [--skip-auto-increment] [--skip-charset] [-V]
Check the difference of MySQL schema (CREATE TABLE)
optional arguments:
-h, --help show this help message and exit
--server1 SERVER1 Comparison source. [Format] user:password@host:port/database
--server2 SERVER2 Comparison target. [Format] user:password@host:port/database
-o OUTPUT_DIR, --output-dir OUTPUT_DIR
Directory to save files. Default is current directory.
--skip-auto-increment
Whether to ignore the difference of "AUTO_INCREMENT=[0-9]+"
--skip-charset Whether to ignore the difference of "CHARSET=[a-z0-9]+"
-V, --version Show command version
Examples
Check the differences
sqldiffer --server1 homoluctus:test@aroundtheworld:3306/aaa \
--server2 homoluctus:test@anothersky:3306/aaa
Ignore charset
sqldiffer --server1 homoluctus:test@aroundtheworld:3306/aaa \
--server2 homoluctus:test@anothersky:3306/aaa \
--skip-charset
Ignore auto_increment and charset
sqldiffer --server1 homoluctus:test@aroundtheworld:3306/aaa \
--server2 homoluctus:test@anothersky:3306/aaa \
--skip-auto-increment \
--skip-charset
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sqldiffer-0.1.0.tar.gz
(6.2 kB
view hashes)
Built Distribution
Close
Hashes for sqldiffer-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 15af40f9de296a6d59c8b8a10e9e3a3394cea7c939e059f60e6ceac722f2260d |
|
MD5 | 0819ec2e00433ceb2a7e8b6c28c68516 |
|
BLAKE2b-256 | feb2cb06fd7a7b3ed908ab6b116a20b20e4aa68fd6cf329b167be829dcab2df3 |