I am trying to consider porting a MS SQL database over to MySQL, the stored procedures looks fairly compatible, and as I search for the trigger functions in Tables, I was unable to find any.
I cannot remember where I saw it, but do remember that MySQL is finally supporting Stored Procedures and Triggers.
I am using MySQL 5.0.45 version.
Anyone can give some suggections. Thanks.
Thanks for the hypertext link to MySQL.
Yes, it is supported, and the Using Triggers help to clarify the topic on Triggers.
It seem to have some advantages over MS SQL, and also seem to have a few disadvantages.
Firstly, the triggers are stored separated from the table, or rather managed seperately.
Triggers can only be activated by SQL, not API - do not know the extend of this limitation.
Triggers cannot use CALL to invoke Stored procedures - a sizeable disadvantage.
Will have to try and convert the database carefully.
Thanks, it sure clarify my need for my DB conversion.
I think you have to use MYSQL 5.x to use triggers.
Hello dude_xyx, care to elaborate if version 5.0.45 is considered version 5.x?
I have not reached the conversion of the triggers yet, as I am presently stuck with building the Web Services and Web applications for my teaching subjects.
Will be helpful if you can clarify. Thanks.
Yes? its posible? but howe its do.....