Synchronizing Database

This topic is empty.

Viewing 5 reply threads

Author

Posts
- February 24, 2003 at 3:35 pm #7719
  
  Cyberbougnat
  Member
  
  Can I synchronize 2 databases on 2 differents servers with SQLyog ?
  
  If yes, how can I do it ?
  
  thanks
- February 24, 2003 at 4:10 pm #13813
  
  Ritesh
  Member
  
  Quote:
  
  Can I synchronize 2 databases on 2 differents servers with SQLyog ?
  
  Yes. You can 😀
  
  Just connect to different servers. Select Tools->Database Synchronization Tool… and in the Combo dropdown you will find databases of both the servers ( i.e. connections ).
  
  Select the databases you want to synchronize and choose one of the output option.
- March 7, 2003 at 2:52 pm #13814
  
  hellraiser40
  Member
  
  This synchronzing means that the structure of the 2 databases is equal.
  
  My question : is it possible to synchronize the data between 2 databases on remote servers or do I have to copy the content from one database to another one?
  
  Also, is it possible to automatize the synchronization/copying of the 2 databases?
- March 7, 2003 at 3:17 pm #13815
  
  Ritesh
  Member
  
  You can only bring the database structure in sync – not the data.
  
  SQLyog will generate the required scripts to bring one database in complete sync with another. So it is “automated” in that sense. However, scheduling this activity to run at regular intervals is not possible.
- March 7, 2003 at 3:30 pm #13816
  
  bluewatercool
  Member
  
  Being able to synchronize the date would be a great feature… more useful on a regular basis that syncing the table structure….
- March 7, 2003 at 3:33 pm #13817
  
  hellraiser40
  Member
  
  not only useful, it would made me and my boss very happy 🙂
  
  maybe an implementation you could work on?? because data sync is something that is used many times and structur sync only once
Author

Posts