Steven Turner wrote: > Hi DJG, thanks for the reply I'm only wanting to use one instance of OpenNMS > which uses only one database but I'm wanting all the information from the > first database to be mirrored in the second database so that every time the > 1st database is updated in some way this information is copied over to the > second which I can then use to extract information from using an external > application. I don't need OpenNMS to be able to use the data from the 2nd > database only to duplicate all insert, update and deletion operations on it. > I looked at triggers initially but these would have to be written for every > table explicitly defining every field in the database. I had thought maybe I > could edit a could of the java classes so it would add the data to both > databases but I don't know where I should be looking. ThanksSteven >
Can't the other application use the same database? It shouldn't hurt anything to add additional tables for other data and the same keys to tie them together. -- Les Mikesell [EMAIL PROTECTED] ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Please read the OpenNMS Mailing List FAQ: http://www.opennms.org/index.php/Mailing_List_FAQ opennms-devel mailing list To *unsubscribe* or change your subscription options, see the bottom of this page: https://lists.sourceforge.net/lists/listinfo/opennms-devel