Hi,
One application is running in two different locations. The database
structure is the same for both. Each database has its own data. For
replication, I cannot apply snapshot of one to the other because the target
will loose its data. I was thinking of exporting their data to an
intermediate(shared) database and then replace each db with this new one
(Assuming the PKs will remain unique).
I'm sure I'm not the first person who has encountered with this situation,
therefore there must be a known solution!
Any help would be greatly appreciated.
Leila