|
Replies:
1
-
Pages:
1
-
Last Post:
Mar 1, 2010 1:10 PM
by: Dwight
|
Threads:
[
Previous
|
Next
]
|
|
|
|
|
|
Bug with Schema Compare and triggers
Posted:
Feb 16, 2010 2:23 PM
|
|
|
Hello.
I use Schema Compare for two DBs, one has triggers, other has not. Toad suggest following script for synchronization:
CREATE TRIGGER `usersection_after_upd_tr`
AFTER UPDATE ON `usersection`
FOR EACH ROWBEGIN
CALL update_guest_privacy();
END;
It fails because of syntax error: "ROWBEGIN" without space. Maybe new line replaced incorrectly.
This is verified in 4.5 and 4.6 version, both are with bugs.
Thank you for your response.
|
|
|
Posts:
68
Registered:
8/22/07
|
|
|
|
Re: Bug with Schema Compare and triggers
Posted:
Mar 1, 2010 1:10 PM
in response to: vanav_i
|
|
|
Vanav,
I'm still working on getting a solution to this. Please, hang in there.
Dwight
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
