SQL Comparer - Synchronize your database versions

Compare and synchronize two SQL database schemas and spot the adaptation among them. an excessively useful software whilst dealing with different variations of a database.

Features

• Copy SQL exports instantly from PhpMyAdmin
• Comparability effects are colour highlighted
• Easily synchronize your database schemas
• Explicit comparability parts can also be overlooked
• Get statistics for each schemas

How does it paintings?

1. evaluate SQL schemas?
   • Press A button to load .sql record into field A
   • Press B button to load .sql document into box B
   • Press Examine A and B and the program will take care of the remainder!
   it is that easy! =)
2. I most effective want to check *, can i do this?
   Sure, you'll be able to evaluate explicit components by myself or define what you want to match. To do that it's important to open the Ignore settings: Tools -> Ignore settings.

   Simply test the weather you wish to forget about and press ok, then press Compare A and B again to see the results. The ignore settings additionally affect the facts.

3. I don't like the colors, can i modification them?
   Sure, you open the color settings: Gear -> Comparability colors where you can modification the font, backcolor and forecolor of any comparability colour.
4. what's an SQL schema?
   it is an outline of the database structure in its formal language, and this comparer is meant for MySQL. here's an instance of a SQL schema: CREATE DESK IF NOW NOT EXISTS `gallery_image_desc` ( `identification` int(ELEVEN) NO LONGER NULL auto_increment, `gallery_idfk` int(ELEVEN) NOW NOT NULL, `imgname` varchar(255) NO LONGER NULL, `desc` text NOT NULL, `display` tinyint(1) NOW NOT NULL default '1', `views` int(11) NOW NOT NULL default '0', PRIMARY KEY (`id`) ); IN CASE YOU don't realize what that is, you probably haven't any use for this comparer
5. Can it discover my construction?
   The Parser is designed to be very forgiving and to acknowledge individual portions. I does not require you to have everything in correct order (but the database might) so it's going to locate such a lot schemas. Believe these two silly schemas:
    
   MySQL syntax: CREATE TABLE `test` ( `mycol` int(11) NOW NOT NULL auto_increment default '0', NUMBER ONE KEY (`mycol`) ); Something else: CREATE DESK take a look at ( auto_increment NOW NOT NULL int 11 NUMBER ONE KEY default '0' mycol );

   The Comparer will scan those schemas and tell you that they're a great match. that's real, excluding the second one is completely invalid SQL CREATE DESK command. Still, may you re-prepare some of its elements you finish up with the same table.

   Desk names may also be strings and nonetheless be regular: CREATE DESK 'this_is_string' ( ... ); These Kind Of options are to ensure better and more flexible SQL Comparer.

who is this for?

have you ever developed PHP application that makes use of MySQL database? Do you've a development database (for your localhost) and a are living one on some website online? Then this tool is for you!
FULL DOWNLOAD