Schema Compare: Database vs. Project: Events not syncronized

[jfricke]

Hello!

I did an schema compare between a database and a project. After I sycronized the database with the project with the option "Refresh comparsion results after successful synchronization" I noticed that the events are not properly synced.

The source database shows for example:

Code: Select all

CREATE EVENT trees_snapshots_delete
	ON SCHEDULE EVERY '1' MINUTE
	STARTS '2011-05-20 03:00:00'
	COMMENT 'delete not neccessary snapshots'
	DO 
BEGIN
DELETE FROM trees_snapshots WHERE keep = 0;
END

and the target project shows:

Code: Select all

CREATE EVENT trees_snapshots_delete
	ON SCHEDULE EVERY '1' MINUTE
	STARTS '2011-05-20 03:00:00'
	COMMENT 'delete not neccessary snapshots'
	DO 

As you can see the part after DO is missing in the project file. This is the case for each event I have defined at the database. I consider this as a bug.

I'm using dbForge Studio for MySQL Professional Edition 5.0.60.
The database version is MySQL 5.1.53

additional information:

The corresponding project file of the event contains the missing code. But the schema compare window does not displaying it correctly.

[vu]

We have reproduced this error. It will be fixed in a month.

[MarkBrock]

I also have the same problem, when will this be fixed?

[alexa]

Hello,

Sorry for the delay.

The issue will be fixed in one of the next builds of dbForge Studio for MySQL.

[MarkBrock]

Hello Support Team,

the problem with the events is still not solved. When do you plan to fix this error.
When do you deploy a new release?

Cheers
Mark

[alexa]

Sorry for the delay on this.

This issue is fixed in the beta version 6.0 of dbForge Studio for MySQL: http://www.devart.com/dbforge/mysql/stu ... nload.html

[MarkBrock]

What about the version 5.x, will it also be fixed in this release?

[alexa]

No, it is not fixed in the version 5.