Hi,
I want to dump triggers from oracle to MYSQL.I dumped data from oracle to MYSQL.Can we dump triggers from my source database(oracle) to target database(MYSQL).
I know that datastage is not used for that, but just curious to know.
cheers;
vijay
triggers
Moderators: chulett, rschirm, roy
'dump'? Trigger != data so you really can't just export from one database and import into another. I would think some manual 'translation' would be in order to get from the Oracle PL/SQL code to whatever MySQL uses for their triggers.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
You are right, you should not be using Datastage for this.
Also you cannot dump triggers like you dump data.
You need to extract the DML, from Oracle for creating the triggers,
modify if required to match with MYSQL standards and run it there.
Also you cannot dump triggers like you dump data.
You need to extract the DML, from Oracle for creating the triggers,
modify if required to match with MYSQL standards and run it there.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.