zi000 / schemasync Goto Github PK
View Code? Open in Web Editor NEWThis project forked from mmatuson/schemasync
A MySQL Schema Versioning and Migration Utility
Home Page: http://mmatuson.github.io/SchemaSync/
License: Other
This project forked from mmatuson/schemasync
A MySQL Schema Versioning and Migration Utility
Home Page: http://mmatuson.github.io/SchemaSync/
License: Other
Project maintaining again. If you want to help us, we really appreciate that. Schema Sync v0.9.5 +++++++++++++++++++ a MySQL schema synchronization utility http://mmatuson.github.io/SchemaSync/ SYNOPSIS ======== schemasync [options] <source> <target> # source/target format: mysql://user:pass@host:port/database # output format: <database>[_<tag>].YYYYMMDD.(patch|revert)[_<version>].sql DESCRIPTION =========== Schema Sync will generate the SQL necessary to migrate the schema of a source database to a target database (patch script), as well as a the SQL necessary to undo the changes after you apply them (revert script). * Schema Sync does not alter your database. It only generates the .sql files containing the differences. You must apply the changes. * Schema Sync does not yet recognize Tables or Columns that have been renamed. A rename will result in the old table or column being dropped and the new one added. * All ADD|MODIFY COLUMN statements have the AFTER (or FIRST) SQL syntax even if no move is required. * COMMENTS and AUTO_INCREMENT values are not by synced by default. See help (-h) for details. * Partitions (MySQL 5.1+) are not yet supported OPTIONS ================= -h, --help show this help message and exit -V, --version show version and exit. -r, --revision increment the migration script version number if a file with the same name already exists. -a, --sync-auto-inc sync the AUTO_INCREMENT value for each table. -c, --sync-comments sync the COMMENT field for all tables AND columns -D, --no-date removes the date from the file format --charset=CHARSET set the connection charset, default: utf8 --tag=TAG tag the migration scripts as <database>_<tag>. Valid characters include [A-Za-z0-9-_] --output-directory=OUTPUT_DIRECTORY directory to write the migration scrips. The default is current working directory. Must use absolute path if provided. --log-directory=LOG_DIRECTORY set the directory to write the log to. Must use absolute path if provided. Default is output directory. Log filename is schemasync.log Download and Install ==================== Prerequisites ------------- * To run Schema Sync, you need to have: - Python 2.4, 2.5, or 2.6 - MySQL <http://www.mysql.com/>, version 5.0 or higher - MySQLdb <http://sourceforge.net/projects/mysql-python>, version 1.2.1p2 or higher - SchemaObject <http://matuson.com/code/schemaobject> 0.5.7 or higher * To run the test suite, you need to install a copy of the Sakila Database <http://dev.mysql.com/doc/sakila/en/index.html>, version 0.8 Standard Installation --------------------- For installation instructions, see http://mmatuson.github.io/SchemaSync/install.htm Status & License ================ It is released under the Apache License, Version 2.0 <http://www.apache.org/licenses/LICENSE-2.0>. You can obtain a copy of the latest source code from the Git repository <http://github.com/mmatuson/SchemaSync>, or fork it on Github <http://www.github.com>. You can report bugs via the Schema Sync Issues page <http://github.com/mmatuson/SchemaSync/issues>
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.