I have the need to have a real time replica of a few of our tables that are stored in an off site location for disaster recovery.
What we would like would be whenever there is a change on table Orders on our internal sql 2000 database, that the same change is then made to the table Orders on a database stored externally, probably by GoDaddy or some similar host.
All changes currently are completed via web pages using classic asp, so if needed, I can just add update / insert statements to the code of the pages, but I'd prefer to do a trigger on the sql side.
So, is it possible to do a sql trigger from a local database to an external database hosted by, say, GoDaddy? Do we need to do any upgrades of our existing sql-2000 server?
Are there any other solutions you can think of to achieve what we are looking for?
In a nutshell, we want to have a real time replica of some tables we choose, we could do the entire database is that is easier also, but it isn't needed.