2 databases need same table infromation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Souris - 16 Apr 2008 13:30 GMT

I have 2 databases are stored in different servers.

I need maintain those tables twice for the same information.

Are there any way to set synchronize them automatically daily or any time
user maintain the database?

Your information is great appreciated,

Reply to this Message

David W. Fenton - 16 Apr 2008 19:17 GMT

> I have 2 databases are stored in different servers.
>
> I need maintain those tables twice for the same information.
>
> Are there any way to set synchronize them automatically daily or
> any time user maintain the database?

Yes, Jet replication works for that. What is the connection between
the servers? Wired LAN? Internet? That will determine how difficult
it is to implement and what methods you can use.

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message

user@domain.invalid - 16 Apr 2008 19:33 GMT

>> I have 2 databases are stored in different servers.
>>
[quoted text clipped - 6 lines]
> the servers? Wired LAN? Internet? That will determine how difficult
> it is to implement and what methods you can use.

Why not redesign to store the data in one place, maintain it once and
use it in both applications?

Bob

Reply to this Message

David W. Fenton - 17 Apr 2008 23:20 GMT

>>> I have 2 databases are stored in different servers.
>>>
[quoted text clipped - 9 lines]
> Why not redesign to store the data in one place, maintain it once
> and use it in both applications?

My assumption was that there was some reason they were not
accessible, but, yes, obviously, one shared data store would be
preferable.

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message