Are these 5 databases on different servers and at different locations or
are they on the same local cluster?
If they are all on the same local cluster you may want to rethink how you
are storing customer data. The design you describe seems redundant.
If you are dealing with multiple servers (and
I need to maintain a sync-ed table across several databases. For example I
have a customer table in 5 databases. If a user of any of the databases
inserts a new customer I need to insert the new record into the other four
databases. But question is updates and deletes.
I can use a trigger an
