Transactional structure changes?

Compares and synchronizes MySQL database schemas.

Moderators: Chris Auckland, eddie davis, Michael Christofides

Transactional structure changes?

Postby matdodgson » Fri May 21, 2010 10:37 am

Hi folks.

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?
matdodgson
 
Posts: 1
Joined: Fri May 21, 2010 10:30 am

Postby Lionel » Thu May 27, 2010 10:56 am

Hi

I am really sorry you have had problems. At the moment the DDL changes are not wrapped an a transaction but my understanding and experiments indicate that DDL operations are not transactional. In fact, if you run a DDL statement it seems to commit the current transaction. This is using InnoDB on version 5.1.45 (I haven't tried it on other storage engines/versions). If I am wrong please let me know!

If you know what caused the synchronization to fail please let me know and I will try and fix the bug!

Lionel
Software Engineer
Red Gate Software
Lionel
 
Posts: 155
Joined: Fri Dec 16, 2005 11:09 am

Postby Lionel » Thu May 27, 2010 10:58 am

Btw way I am very sorry it took me so long to reply to your post!

Lionel
Software Engineer
Red Gate Software
Lionel
 
Posts: 155
Joined: Fri Dec 16, 2005 11:09 am


Return to MySQL Compare

Who is online

Users browsing this forum: No registered users and 1 guest