Re: How to treat several identical database as one.

David Williams <djw@smooth1.demon.co.uk> wrote: : The only problem is that we don't want any more hardware involved. : A datawharehouse would need more disks/ CPU power and a replication : agent running to keep data in sync. A datawarehouse would be nice : but the users have no budget for one. : : Any other ideas??? Put a simplified "datawarehouse" on one of the machines. All you would need are extra disks and some way of loading data into the tables. If your users have no budget for extra disks you are out of luck. How this can be with the current prices of disks I can't understand though. 4 Gb of disk equal something like the cost of 10 consulting hours in our situation. Your mileage may wary but still should be possible if your databases aren't very large. As to CPU power this solution would probably need less than doing the same reporting accross three machines. The "replication agent" you might be able to write yourself depending on the users requirements. A nightly run will suffice in most cases, but may be not in yours. If it is may be you can transfer data based on some date/datetime field giving insert/last modified time? Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company