Datanamic SchemaDiff for MySQL

Compares and synchronizes MySQL database schemas...

Quickly Compare and Synchronize MySQL Database Schemas

software to synchronize mysql schemas
  • Compare and synchronize MySQL database schemas
  • Supports MySQL version 3,4 and 5
  • Cross MySQL versions synchronization is supported
  • Visualize the differences between database schemas
  • Generate synchronization scripts
  • Automate your synchronization process with command-line utility
  • Intelligent auto-mapping of (renamed) database objects

When the structure (schema) of your MySQL database changes, you often spend a lot of time creating complex synchronization scripts. Performing such tasks manually can be error prone. Datanamic SchemaDiff for MySQL provides the ability to compare and synchronize MySQL database schemas. After the comparison is performed, Datanamic SchemaDiff for MySQL generates the synchronization script that can be used to update the destination database schema to match the source database.

With Datanamic SchemaDiff for MySQL you can see what differences exist between two MySQL database schemas. The tool generates the SQL to synchronize the database schemas. You avoid mistakes with deploying structure changes from one database to another database (for example: test environment to production environment). This is a necessary capability for effective database change management.

Challenge

Many organizations struggle with efficient processes to manage MySQL schema changes. You want to ensure that database schemas are synchronized. A database schema change applied to one database environment (development, test, production etc) must make it other MySQL database environments also. DBAs often spend significant time creating complex synchronization scripts, even though the update itself might be a simple one. You need a solution that will automatically compare and identify the object differences between two MySQL database schemas and then synchronize them.

Solution

Datanamic SchemaDiff for MySQL is an easy-to-use database schema comparison and synchronization tool. The tool will give you the full picture of all database schema differences. Once your database schemas are compared, you can view the object differences and generate the necessary synchronization script to update the destination database.

Datanamic SchemaDiff for MySQL simplifies database administration tasks and increases DBA productivity.

Features

MySQL Connectivity

  • Direct access to MySQL databases.
  • Multiple MySQL versions supported.
    MySQL version 3,4 and 5 are supported.
  • Cross MySQL versions comparison.
    You can for example synchronize a MySQL 4 and a MySQL 5 database.

Schema Comparison

  • Database schema to database schema comparison.
    Connect to two MySQL databases and compare the objects in those databases.
  • SQL script to database schema comparison.
    Connect to a MySQL databases and select a SQL script representing a database and compare the objects in both sources.
  • Schema mapping.
    Mapping schemas enables you to compare database objects that belong to the same or different schemas.
  • Comparison options.
    You can control what is compared and what is seen as a difference. Use the comparison options such as case insensitivity, ignore constraints and 30 other options, for that.
  • Object mapping.
    Mapping is used to connect the objects to be compared. Mapping of database objects in source and destination database is done based on names. If no object with the same name was found, intelligent routines are used to find out if an object must be mapped to an object with another name. The tool automatically detects renamed database objects.
  • Compare all database object types.
    Compare tables, procedures, indexes, views, triggers, constraints etc.
  • Generate HTML reports with database differences.

Schema Synchronization

  • Synchronization options.
    You can ignore table elements or objects descriptions for example, for synchronization.
  • Synchronize a complete database or only a selection of objects.
    You can select the database objects you want to synchronize.
  • Synchronization script generation.
    Generated script handles object dependencies.

Comparison Results

  • Visual representation of differences.
    A side-by-side, colour-coded comparison overview makes it easy to pinpoint at a glance similarities and differences between two database objects.
  • Summary of differences between two databases.
    The summary includes objects in source but not in destination (or vice versa), identical objects and the totals of selected objects.
  • Object type filtering.
    Filtering the comparison results enable you to limit the display of objects to certain types of database objects (for example, show only tables and/or views).
  • Status filtering.
    Filter the comparison results based on the status (identical, different, etc...) of the compared object.

Automation of Synchronization Process

  • Automated object comparison and synchronization.
    A command line utility is included to automate your compare and synchronize process.
  • Project-oriented.
    Save your comparison plan to a SchemaDiff project.

Screenshots

Review the differences between the source and destination database.

Generate an alter script to synchronize the databases.

Filter the comparison results for a better overview.

Pricing

Datanamic SchemaDiff for MySQL costs $ 199 for a single user license (EULA).

Upgrade Protection/Support is optional and costs 20% of the initial purchase price per year.

Or upgrade

Tech specs

Operating System: Windows 10/8.1/8/7/Vista/XP

Memory: 1 GB minimum (2 GB recommended)

Hard Disk: At least 20 MB of free disk space

Databases: MySQL 3,4, 5

Try Datanamic SchemaDiff for MySQL for free

Download a free trial, and start saving time with your database deployments today.

Bundle It And Save!

If you buy our software in bundles you save a great deal of money on the price of the individual database tools.