I have a number of large database's which are linked to tables in an informix server.
Each of these db's are performing different tasks and each db is of quite substantial size. For example one does my stock another looks after debtors while another looks after creditors etc.
For my month end reporting I need to run routines in each respective db.
What I was thinking is if I could link all the db's together, maybe using another db which would run all the routines I need to at month end, rather than running them separately.
My questions are:
Would this be a good idea? would it necessarily be more efficient?
If so how could I do it?
I would appreciate any ideas.
Many thanks as always