- Home
- Show all categories
- About Webyog support and about this FAQ
- About the SQLyog program

- Connection issues

- Using the GUI
- Managing your MySQL Database Systems

- Database Structure Synchronization
- MySQL DATA synchronization
- Notification Services
- ODBC and Migration
- Backup/Restore
- SQLyog Job Agent (SJA)

- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Instant Response
- Sitemap
MySQL DATA synchronization
Is it true that I need a Primary Key to use the SQLyog Synchronization Tool?
No - not anymore! From SQLyog version 5.0 synchronization is possible without a Primary Key as well.
But it is recommended to use a Primary key when it is possible to do so, because
- without a PK you cannot UPDATE rows. Only INSERTs and DELETEs are possible. Non-existing rows on target that exist on source will be inserted and existing rows on targets that don't exixt on source will be deleted (if not 'never delete' is set). A row is identifed by its complete dataset
- it also reduces the complexity of the calculations that the client running the Synchronization tool need to perform.
But in some cases applications will only accept database schemas that have a very specific structure - a structure generated by the application itself. Sometimes adding a PK to the tables will cause the application to refuse working with the database.
Even in such and similar cases you can now use the SQLyog Synchronization tool.
Tags: -
Related entries:
- Do I need PHP to use SQLyog with MySQL?
- SQLyog gives you the most options for connecting to MySQL
- Welcome to the Webyog FAQ
- Installation and upgrading
- Buying and Licensing SQLyog
Last update: 2005-11-30 08:38
Author: Peter Laursen
Revision: 1.0
You can comment on this entry