SQLyog MySQL Admin FAQ - Does the SQLyog 'Schema Sync Tool' synchronize MySQL objects (Stored Procedures, Functions, Triggers, Views and Events)?

SQLyog MySQL Admin FAQ

Navigation

2 users online | 2 Guests and 0 Registered

Latest FAQs

SQLyog Version History (2014-06-08 10:22)
I get error 1130 "Host is not allowed to ... (2014-01-30 12:21)
About CHUNKs and BULKs (2014-01-09 11:53)
SQLyog is a client for the MySQL server - ... (2013-08-04 04:48)
Problems creating a functional DSN on 64 bit Windows. ... (2013-07-22 08:34)

Sticky FAQs

Database Schema Synchronization

ID #1069

Does the SQLyog 'Schema Sync Tool' synchronize MySQL objects (Stored Procedures, Functions, Triggers, Views and Events)?

Yes, it does! That was included with SQLyog version 5.1. The SCHEMA SYNC tool now syncs all available information from the database schemas and can be used across all MySQL versions with these exceptions:

1) it does not 'strip out' partition information when syncing MySQL 5.1 partitioned tables to MySQL 5.0 (it does when syncing to versions before that).

2) MySQL TABLESPACES (introduced in MySQL 5.1 for NDB tables and in 6.0 for FALCON tables) are not sync'ed. This limitation applies to the TABLESPACE itself as well as TABLESPACE usage in CREATE TABLE statements

Note that charset/collation 'defaults' for databases, and tables are synced from version 6.0 and charset/collation information for individual columns is sync'ed from version 6.1. Support for EVENTS was added in version 6.5