Interview Question in Internet Information Server


 

Interview Question :: How do I get 2 databases to cooperate

Basically I've got a local database in which I keep information on stock, and a database that serves an e-commerce website.

Both databases are identical, and what I do at the moment, is to keep all stock info in one of the databases, and at the end of each day I export the data from one and import it to the other.

Is there a way of making things a little more effortless? Perhaps by linking the database on the server to the local one? Is this is even possible?

One thing I'm not considering is to put the day to day operations on the shop in jeopardy, by operating a remote database (making me dependent on an internet connection).

No need to be too technical, I'm just trying to get an idea of whats feasible.

Note: the local database needs to be compatible with mac.
by ksk