August 19, 2005 at 7:13 am
Hi!
I have a situation... I have 3 servers in 3 different locations. I have about 2 dozen tables that must be in sync between all 3 locations. This needs to be as close to real time as possible. What is the best way to do this?
August 19, 2005 at 9:12 am
Can you elaborate on sync'd?
Is it the same table definition, with most the same data, just few rows are different?
Each table at each location holds completely different rows? Will you have issues with primary keys?
What is the size of your tables?
Are your tables basically static, or will your application be doing inserts, updates, deletes to the table when you perform this sync operation?
Having primary key issues here will be your biggest hurdle.
Are the tables being replicated?
August 19, 2005 at 11:26 am
OK... Here is the situation...
All locations will be entering orders into the system. All location need access to all orders placed regardless of the origin. Plant A will enter an order and then plant B will plan the material usage for that order. Plant C may look up order status information for a customer on the phone. That is the typical senerio. The table will have about 10000 unique rows per location. There is a unique job number assigned that will be unique across all locations. The data will be entered and some updates done, but not more than a few. The tables are not now being replicated, but that is a possibility if this situation warrents it.
THanks!
Joe
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply