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
