updating two databases

[parames]

Hi list.. Really have no idea how to solve this problem..

We have just developed a web base system and going to upload it to an external server,MS-SQL server. (we rent a hosting server)

The problem is, we are using two databases. One is for internal use(intranet system) and one is for external use (in the external server).
Every day we got to update this two databases.

All the changes in the database A must be updated in database B and all the changes in database B must be updated in database A.
I really have no idea how to do this..

Please help..
rgds,
parames.s

 

[Shilohcity]

Really need some more info to help with this....How are you curently updating the databases?

If you are using asp to do this then it should be a straightforward although relatively server and connection intensive process. You simply need to pass the relevant updates to the relvant databases.

Just some basic thoughts.


Justin.X-)
"Creativity is the ability to introduce order into the randomness of nature." Eric Hoffer

Visit me at

http://www.dfodesign.co.nz