Re: [opennms-devel] Database duplication

Why do you want to do what you mentioned?  What are your functional  
requirements?

In short: you most likely don't want to do what you are asking about.   
There would be a high amount of effort invested to make such a change  
it will have nasty architectural, performance, and data consistency  
problems.  You most likely want to use the model importer and maybe  
things like the asset table, node categories, service application  
groupings, and/or adding one or more tables that get joined with the  
appropriate opennms tables to do what you want.

You would probably have to update hundreds of queries, and then  
there's the question of how you deal with unique IDs and foreign keys  
between databases.  What about cases where we have a uniqueness  
constraint on a column but data is split between multiple databases  
(ie: what if data with the same value for such a column  exists in  
both databases)?  What about new data and updates (which DB to they go  
to)?  What about joins across databases (eg: node is in database 1,   
but its interfaces are in database 2)?


         - djg

On Apr 9, 2008, at 5:00 AM, Steven Turner <[email protected]>  
wrote:

> Hi,
>
> I'm wanting to make a duplicate of the OpenNMS database which is  
> residing on the same server but with an additional column attached  
> to all tables which has its content generated by a function. This  
> duplicate database will have excatly the same SQL querys performed  
> on it as the original OpenNMS database so I need to modify the code  
> in order to perform the querys on both databases, rather than just  
> the single standard OpenNMS db.
>
> I don't know which files I need to modify so any pointers to where I  
> should be looking and what files relate to the database transactions  
> would be greatly received.
>
> Best regards
>
> Steven Turner
>
> A prize an hour, 24 hours a day. Try Big Snap now!
> --- 
> ----------------------------------------------------------------------
> 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

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