Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

hronize MySQL objects (Stored Procedures, Functions, Triggers, Views and Events)?

April 26, 2017events functions MySQL objects procedures stored triggers

0

Posted

hronize MySQL objects (Stored Procedures, Functions, Triggers, Views and Events)?

1 Answer

0

Posted

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.