SchemaSync - 源码 - 源码 - 免费下载

SchemaSync

文件大小： unknow

源码售价： 5 个金币积分规则积分充值

资源说明：A MySQL Schema Versioning and Migration Utility

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 format: mysql://user:pass@host:port/database
# output format: [_].YYYYMMDD.(patch|revert)[_].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 _. 
                      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 , version 5.0 or higher
    - PyMySQL , version 0.6.2 or higher
    - SchemaObject  0.5.7 or higher
* To run the test suite, you need to install a copy of the Sakila Database , 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 . 

You can obtain a copy of the latest source code from the Git repository , or fork it on Github .

You can report bugs via the Schema Sync Issues page

部分文件列表（点击文件名可查看文件内容）

					
									本源码包内暂不包含可直接显示的源代码文件，请下载源码包。