[ad_1]

To get this product on 50 p.c contact me on this link

LIVE PREVIEWBUY FOR $23

Compare and synchronize two SQL database schemas and see the distinction between them. A really useful software when coping with totally different versions of a database.

Features

• Copy SQL exports immediately from PhpMyAdmin
• Comparison outcomes are coloration highlighted
• Easily synchronize your database schemas
• Specific comparability parts may be ignored
• Get statistics for each schemas

How does it work?

1. How to match SQL schemas?
   • Press A button to load .sql file into field A
   • Press B button to load .sql file into field B
   • Press Compare A and B and this system will care for the remainder!

   It is that straightforward! =)

2. I solely need to evaluate *, can I do this?
   Yes, you’ll be able to evaluate particular parts alone or outline what you need to evaluate. To do this it’s essential to open the Ignore settings: Tools -> Ignore settings.

   Simply examine the weather you need to ignore and press okay, then press Compare A and B once more to see the outcomes. The ignore settings additionally have an effect on the statistics.

3. I don’t like the colours, can I alter them?
   Yes, you open the colour settings: Tools -> Comparison colours the place you’ll be able to change the font, backcolor and forecolor of any comparability coloration.
4. What is an SQL schema?
   It is an outline of the database construction in its formal language, and this comparer is meant for MySQL. Here is an instance of a SQL schema:

   CREATE TABLE IF NOT EXISTS `gallery_image_desc` (
     `id` int(11) NOT NULL auto_increment,
     `gallery_idfk` int(11) NOT NULL,
     `imgname` varchar(255) NOT NULL,
     `desc` textual content NOT NULL,
     `present` tinyint(1) NOT NULL default '1',
     `views` int(11) NOT NULL default '0',
     PRIMARY KEY  (`id`)
   );

   If you have no idea what that is, you in all probability don’t have any use for this comparer

5. Can it detect my construction?
   The Parser is designed to be very forgiving and to acknowledge particular person components. I doesn’t require you to have all the things in appropriate order (however the database would possibly) so it should detect most schemas. Consider these two foolish schemas:
    

   MySQL syntax:

   CREATE TABLE `take a look at` (
     `mycol` int(11) NOT NULL auto_increment default '0',
     PRIMARY KEY  (`mycol`)
   );

   Something else:

   CREATE TABLE take a look at (
     auto_increment NOT NULL int 11 PRIMARY KEY default '0' mycol
   );

   The Comparer will scan these two schemas and let you know that they’re a good match. Which is true, besides the second is totally invalid SQL CREATE TABLE command. Still, would you re-organize a few of its parts you find yourself with the identical desk.

   Table names may even be strings and nonetheless be accepted:

   CREATE TABLE 'this_is_string' ( ... );

   All these options are to make sure higher and extra versatile SQL Comparer.

Who is that this for?

Have you developed PHP software that makes use of MySQL database? Do you will have a growth database (on your localhost) and a stay one on some web site? Then this software is for you!

[ad_2]

To get this product on 50 p.c contact me on this link

Source