Compare Schema Mysql

MySQL Upgrade can create an array with the definition of the schema of a given MySQL database and serve it for download.Definitions of database schema can also be compared and one version can be upgraded to the other.

Schema comparison is an important and useful way to know the difference specially when schema upgrade is done and compare it with referene version to ensure that upgrade was successful. This tool provides an easy to use GUI interface for comparing the two schema. The settings for schema elements...

Narya is a forum/incubator software, based on a Python/Zope/MySQL platform. Emphasis on graphics support and collaboration for space and technology development. Compare PHP/MySQL forums.


Platforms: Windows, Mac, Linux

Schema-compare is a script that will compares two database schema and show the differences side-by-side. Schema-compare can also generate SQL statements that will alter the old database to match the schema of the new database. The comparisons are correct, but the SQL statements at the bottom...


Platforms: *nix

The table schema of a MySQL database can be retrieved and exported to a XML definitions file by one class.Another class can do the opposite, i.e. read the definitions of a MySQL database schema from a XML file and update the currently installed database schema to match the definitions from the...


Platforms: PHP

Schema-compare is a PHP script that will compare two database schema's and show the differences side-by-side. It will also generate sql statements that will alter the old database to match the schema of the new database.


Platforms: Windows, Mac, *nix, PHP, BSD Solaris

phpMyDBCompare can be used to compare the schema of two MySQL databases. It can connect to a local and a remote MySQL database servers. The remote server is connected using the ODBC API.phpMyDBCompare retrieves the list of tables of each database and the list of fields of each table. The...


Platforms: PHP

MySQL Structure Magic can analyze the schema of a MySQL database and export it as a PHP array definition or in a XML format. Previously exported schema definitions can also be imported.With an initial and final schema definitions MySQL Structure Magic can compare them and determine the necessary...


Platforms: PHP

Audio::DB::Adaptor::dbi::mysql implements a specific mysql database schema that is compatible with Audio::DB. It inherits from Audio::DB. In addition to implementing the abstract SQL-generating methods of Audio::DB::Adaptor::dbi, this module also implements the data loading functionality of...


Platforms: *nix

dbForge Studio for MySQL is a free MySQL and MariaDB front-end client for database management, administration and development. Devart's MySQL GUI tool provides utilities to compare, synchronize, and backup MySQL databases with scheduling, and gives possibility to analyze and report MySQL tables...


Platforms: Windows

MySQL Workbench enables a DBA, developer, or data architect to visually design, generate, and manage all types of databases including Web, OLTP, and data warehouse databases. It includes everything a data modeler needs for creating complex ER models, and also delivers key features for performing...


Platforms: Windows

SQLyog is a compact Win32 Front End for the MySQL database server. The program is aimed at users that are familiar with SQL statements and need an easy to use, no fuss, graphical interface to execute SQL queries. The program supports execution of multiple queries and selected (highlighted) or...


Platforms: Windows

DBScribe is a free MySQL database documentation tool that creates precise technical documentation of every detail of a database schema in moments. DBScribe supports a rich set of documentation styles, output formats (HTML, CHM, MS Word Document), wizard and command line interfaces, complete...


Platforms: Windows

EMS DB Comparer for MySQL is an easy to use application, which was created for database comparison and synchronization. It allows you to view all the differences in compared database objects and execute an automatically generated script to eliminate all or selected differences. Having EMS DB...


Platforms: Windows

Data Wizard for MySQL is a very useful toolkit for managing your MySQL data. It includes the following modules: Data Pump: · Converts schema and data from any ADO-compatible database to MySQL. · Transfers tables, indexes, and foreign key constraints. · Migrates source objects directly to...


Platforms: Windows

Database development IDE for MySQL with many features: visual object editors, schema browser, SQL Insight, two-way visual query builder, templates & catalogs, export and import tools and much more.


Platforms: Windows

Ispirer's business is grounded on a cutting-edge migration tool SQLWays, which has the potential and powerful outcomes. It can take full control of the entire migration cycle providing high automation of all migration phases. SQLWays converts stored procedures, functions, triggers, database...


Platforms: Windows, *nix, DOS

Interprets database schemas which are written in XML. Takes the schema either directly or via a file, parses it, generates the SQL necessary and (optionally) executes the SQL.Works only with MySQL but could be ported to other RDBMS very easily.


Platforms: PHP

There is one class that can access a given MySQL database and retrieve the schema of tables, fields, indexes and constraints.The retrieved MySQL database scheme can be used to generate an XML document with a structure of information that describes it.


Platforms: PHP

EMS MySQL Manager is an inexpencive but powerful and effective tool for MySQL Server administration and object management. Its Graphical User Interface (GUI) allows you to create/edit all MySQL database objects in most easy and simple way, run SQL scripts, manage users and administrate users'...


Platforms: Windows