How to compare the structure of two tables and update the other?

1

The question is the same as the title:

How to compare the structure of two tables and update the other?

I have an online database, which I want to update the structure of the database. I also have some customers who use banks tapped offline on their machines.

I want my client to have the internet compare his bank structure with that of the online bank. If there is a difference, it will update.

    
asked by anonymous 17.03.2017 / 00:04

1 answer

1

You can do it through the MySql Workbench:

First, you have to convert your schema to a model, so do:

  • Database > Reverse Engineer
  • Select the database > Next
  • Next
  • Select the schema you want to convert > Next
  • Next
  • Select the tables > Run >
  • Next
  • Finish
  • After converting the schema to a model, do:

  • Database > Synchronize with Any Source
  • Next
  • Send Updates To > Destination Database Server > Next
  • Fill in the Target Bank data > Next
  • Next
  • Select the table you want to synchronize > Next
  • Next
  • All available changes will be listed > Next
  • Run >
  • A txt will be generated with the possible changes and clicking on Execute > will execute all the changes and leave the structures of the two banks identical.

    If you have an error, it will be listed as well.

        
    09.04.2017 / 20:35