>Yes with link-realtime, I am understanding that both sites will be updating-querying-editing records, I know that the "real-time update of the records" will be my first problem to tackle, that's why I was enquirying you all guys abou past experiences on how to deploy in this kind of enviroment.
>
>Mark Oliva
>
>
>>>I have two DB in two different locations, the client is in the process of installing his DSL line and wants to have both databases link-realtime over this comm line, windows NT sp4 is the plataform.
>>>Any drawbacks I should be aware before I began to embark into this connection adventure?
>>>
>>>TIA
>>>
>>>Mark Oliva
>>
>> When you say Link Real Time, what do you mean? Will people at both sites be updating both local and remote tables? Will one site be viewing/querying information from remote and updating locally? How are you linking the databases?
>>
>>Wayne

I would suggest using a database server and implementing replication. This would take out of the mix any of the overhead of trying to update two sites concurrently. And as for having the same data at both sites all the time, it would just require a very fast very reliable link between the two systems.


Wayne