innodb and myisam tables

Compares and synchronizes MySQL database schemas.

innodb and myisam tables

Postby collieart » Thu Oct 18, 2012 9:23 am

First might I just say that I've been waiting *years* for red gate to make mysql versions of red gate sql compare and sql data compare. I've used Sql compare / Sql data compare for years on Sql server and these are amazing tools! Great to see Sql compare for mysql.

Anyway, I am comparing the structure of 2 mysql databases. During the synchronisation, I got an error message from sql compare and the sync did not complete. Unfortunately, I notice that the synchronisation has been partly completed so the structure changes were not wrapped in a transaction. This is not good!

The database in question has a mix of innodb and myisam tables - perhaps this has something to do with it?
Posts: 1
Joined: Thu Oct 18, 2012 9:19 am

Postby Michael Christofides » Fri Oct 19, 2012 2:49 pm

Thanks for the kind message. I've forwarded to our development team but believe the problem may actually be whether schema changes can even be wrapped in a transaction in MySQL. Please correct me if I'm wrong, but I've included a couple of similar questions posted online who's answers suggest this: ... ansactions,548 ... #msg-54955
Michael Christofides
Posts: 97
Joined: Wed Apr 20, 2011 5:37 pm
Location: Red Gate Software

Return to MySQL Compare

Who is online

Users browsing this forum: No registered users and 0 guests