I'm working on a slew of triggers. Naturally I'm developing them on my test database and when done I'll need to port them over to the live one. What's the quickest and easiest way?

Roy Lambert

Roy.

I am a novice compared to you but I'll tell you what I do.

I use three types of triggers: After Insert, After Update and After Delete. When I update
or create trigger I save it in as SQL file with the name InsertXXXX or UpdateXXXX or
DeleteXXXX where XXXX is the tablename.

I have developed a procedure that first delete all triggers of database, gets all SQL
files and create it.

I hope you understand my "spanglish" and it help a little to you.

Regards.

Francisco J. Fernandez
NewTRON Informatica

Francisco


What I decided to do this time was reverse engineer, cut the bits I needed out of the script and use that.

Roy Lambert