Updating local and remote SQL databases

[Craigieboy]

Can someone advise me how (using ASP, global.asa, etc...) I can update a SQL database on a LAN and at the same time update an identical copy of the database remotely online. I am happily using ASP to work with the SQL database in a local environment, however is there a way of dynamically updating both?

I look forward to someone's views on this and any assistance, no matter how small, would be greatly appreciated.

Kind regards,
Craig

 

[shaddow]

If u want to update both the sql servers from asp u need to use 2 connections one for 1-st server (main server) one for second server(copy server or backup server) and u have to use tranzactions.
first u do a tranzaction (execute a querry) with 1 server and if the tranzaction is ok then update the 2 server also in an tranzaction

Or u could use an component witch u create in your asp file who do all the stuff

Or u could use stored procedures from first server to update table in the second server...

Or u could set up a SQL Server network witch replicates the data from 1 server to other servers or if one server crushes other take his palce...

Hope this gives u an ideea...

________
George, M