DSXchange

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

'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.

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.