We have a bit of a conundrum at the moment.
ANSI SQL solutions please.
We have two databases located at two different geographic locations and will be using the web for all traffic between the two locations. We have a few tables common between the two databases that need to be sync'd periodically (i.e. at the end of the day). With such syncs, we are worried about many things like security, congested traffic (could be thousands of records), and data integrity.
The end game is to store files in each record (up to 10MB) so the sync needs to be efficient. (Not a priority at the moment.)
There may be records that need to be sync'd both directions (i.e a column on one updated, then a column on two updated, the one record needs these two changes).
What software/hardware options are there out there?
Is there another way without using triggers (want to get away from this)?
Thanks, been a while since I dealt with these technologies.