schemalex - Generate difference sql of two mysql schema

  •        42

This tool can be used to generate the difference, or more precisely, the statements required to migrate from/to, between two MySQL schema.You can also use URI formatted strings as the sources to compare, which allow you to compare local files against online schema, a version committed to your git repository against another version, etc.

https://github.com/schemalex/schemalex

Tags
Implementation
License
Platform

   




Related Projects

node-mysql2 - :zap: fast node-mysql compatible mysql driver for node.js

  •    Javascript

MySQL2 project is a continuation of MySQL-Native. Protocol parser code was rewritten from scratch and api changed to match popular mysqljs/mysql. MySQL2 team is working together with mysqljs/mysql team to factor out shared code and move it under mysqljs organisation. MySQL2 is free from native bindings and can be installed on Linux, Mac OS or Windows without any issues.

Cobar - Proxy for sharding databases and tables

  •    Java

Cobar is a proxy for sharding databases and tables,compatible with MySQL protocal and MySQL SQL grama,underlying storage only support MySQL for support foreground business more simple,stable,efficient and safety。

MySQL Workbench - Visual database design tool for MySQL

  •    C++

MySQL Workbench is a visual database design tool. The tool is specifically for designing MySQL database. MySQL Workbench provides DBAs and developers an integrated tools for Database Design & Modeling, Query browser, Database Administration.

D.E.M.O.N MySQL Tweaker (DEVELOPMENT ON HOLD)

  •    DotNet

D.E.M.O.N Studio MySQL Tweaker, a fast and easy-to-use Mysql tools. Add this to your project, install , start, and stop mysql service with a little coding work. Love MySQL , Love MySQL Tweaker

kingshard - A high-performance MySQL proxy

  •    Go

kingshard is a high-performance proxy for MySQL powered by Go. Just like other mysql proxies, you can use it to split the read/write sqls. Now it supports basic SQL statements (select, insert, update, replace, delete). The most important feature is the sharding function. Kingshard aims to simplify the sharding solution of MySQL. The Performance of kingshard is about 80% compared to connecting to MySQL directly.kingshard is under the Apache 2.0 license. See the LICENSE directory for details.


mysql_utils - Pinterest MySQL Management Tools

  •    Python

It is hoped that this code will be useful to you as an example of working implementations of DB tools. MySQL servers at Pinterest are launched, live, and die with only the rarest of configuration changes. Upgrading kernels, MySQL versions, and any other changes that would require a restart of the database are never done in-place. Instead, these actions are always performed through server replacements and failovers/slave promotions as needed. This choice has greatly simplified our automation by removing the need to manage intermediate state.

Maatkit - Power tools for open-source databases

  •    Perl

Maatkit is a toolkit for users, developers, and administrators of open-source databases. Most of Maatkit’s functionality is designed for MySQL. It makes MySQL easier and safer to manage. Maatkit could be used to prove replication is working correctly, fix corrupted data, automate repetitive tasks, speed up your servers, and much more.

go-mysql - a powerful mysql toolset with Go

  •    Go

A pure go library to handle MySQL network protocol and replication.Replication package handles MySQL replication protocol like python-mysql-replication.

go-mysql-elasticsearch - Sync MySQL data into elasticsearch

  •    Go

go-mysql-elasticsearch is a service syncing your MySQL data into Elasticsearch automatically.It uses mysqldump to fetch the origin data at first, then syncs data incrementally with binlog.

HeidiSQL - A lightweight interface to MySQL

  •    Pascal

HeidiSQL is a lightweight, fast and flexible interface to the popular MySQL-Database. It allows you to browse and edit your databases, tables, views, stored routines and triggers from an intuitive Windows interface.

mysql-audit - AUDIT Plugin for MySQL

  •    C

A MySQL plugin from McAfee providing audit capabilities for MySQL, designed with an emphasis on security and audit requirements. The plugin may be used as a standalone audit solution or configured to feed data to external monitoring tools. If reporting a bug, please describe the problem verbosely. Try to see if it reproduces and include a detailed description on how to reproduce.

mysql2mongo - MySQL to MongoDB importer

  •    PHP

MySQL to MongoDB importer. The scripts are using simple relational to non-relational (r2n) mapping mechanism that should let You automagically convert Your MySQL database into MongoDB set of collections.

DMOZ RDF parser into MySQL

  •    PHP

A package which parses the latest freely available RDF files available at DMOZ and inserts them into two MySQL tables. Once these RDF's are inserted into MySQL, you are able to integrate them into your site's search engine in any way you like.

orchestrator - MySQL replication topology management and HA

  •    Go

orchestrator actively crawls through your topologies and maps them. It reads basic MySQL info such as replication status and configuration.It provides with slick visualization of your topologies, including replication problems, even in the face of failures.

MySQLoader

  •    C++

MySQLoader is a small KDE4 application for the system tray. You can start/stop the MySQL server and launch the MySQL tools like Query Browser, Workbench and MySQL Administrator.

awesome-mysql - A curated list of awesome MySQL software, libraries, tools and resources

  •    CSS

A curated list of awesome MySQL software, libraries and resources.

mysql-connector-python - MySQL Connector/Python is implementing the MySQL Client/Server protocol completely in Python

  •    Python

MySQL Connector/Python is implementing the MySQL Client/Server protocol completely in Python. No MySQL libraries are needed, and no compilation is necessary to run this Python DB API v2.0 compliant driver. Documentation & Download: http://dev.mysql.com/doc/connector-python/en

Chinook Database

  •    

Chinook is a sample database available for SQL Server, Oracle, MySQL, etc. It can be created by running a single SQL script. Chinook database is an alternative to the Northwind database, being ideal for demos and testing ORM tools targeting single and multiple database servers.

MySQL Administration Tools

  •    Perl

The MyCAT project is an open-source toolset for managing MySQL/Linux servers, currently composed of tools that: monitor replication, monitor and rotate binary logs, and allow remote shell access to arbitrary groups of servers.