Linking databases out of state??

[Zonie32]

Not sure what forum to post this in. I have one database that I am creating and one table in it is updated by our California company and the other tables are updated by our local Arizona company.

How can we be sure that on a minute by minute basis that their updates transfer over to our database and vice versa. The info in this database is going be used throughout each day, every day.

Any info is appreciated! thanks.

 

[Mike555]

Sounds as though SQL Server would be more efficient for this, as SQL's replication tools would more efficiently manage a db over geographically distant locations.


--
Not until I became a Network Administrator did the error message "See your Network Administrator for assistance" become petrifying.