Devart Forums

Posted: **Thu 05 Jan 2012 14:39**

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.

Posted: **Thu 05 Jan 2012 15:42**

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

Posted: **Tue 06 Mar 2012 12:05**

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

Posted: **Wed 07 Mar 2012 11:45**

Hello,

Sorry for the delay.

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

Posted: **Wed 13 Feb 2013 10:47**

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

Posted: **Wed 13 Feb 2013 15:53**

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

Posted: **Thu 14 Feb 2013 07:09**

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

Posted: **Thu 14 Feb 2013 09:06**

No, it is not fixed in the version 5.

Devart Forums

Schema Compare: Database vs. Project: Events not syncronized

Schema Compare: Database vs. Project: Events not syncronized

Re: Schema Compare: Database vs. Project: Events not syncronized

Re: Schema Compare: Database vs. Project: Events not syncronized

Re: Schema Compare: Database vs. Project: Events not syncronized

Re: Schema Compare: Database vs. Project: Events not syncronized