Added --hash (-H) command line option

Use --hash (-H) to choose the hash function on the CLI:

Example:

db-sync --user root --password mypass --hash sha1 127.0.0.1 111.222.3.44 web.customers

Added quiet option and return correct error code on failure

• added the --quiet (-q) option to suppress logging
• return correct non-zero error code from cli tool on error
• allow port to be specified in source/target DSN on cli (host:port)

Quieter output by default. --vebose (-v) option added

v3.1.0

quieter output

Pre-Release V3

Its still in development, but has major advantages over the old version.

• Works on compound primary keys
• Works where primary key columns are not integers
• Binary search for inconsistencies
• Fixed MD5 - hash generation bug
• Allows deletion of data from target table no longer in source
• Better tests
• All identifiers quoted correctly

Missing Features:

• Command only allows syncing of a single table, not whole database (additional command will be added to do whole database)
• Cannot choose to only compare certain columns - all synced columns will be compared (additional option to ignore columns, e.g. long text fields, where doing comparison)

Version 2.5

v2.5.0

Update README.md

Return affected row count

v2.4.0

affected row count

Gap skip optimisation

Only skip gaps when no rows were found

Skip large gaps in primary key

v2.2.0

skip large gaps in index

v2.1.0

built in connection

v2.0.0

Bundled Dbal