Synchronizing two databases on different servers
0
votes
1
answer
370
views
I have two databases on different servers. Each one of them contains 350+ tables and users have read and write access on both databases.
I want to synchronize them, but in special cases, like if a specific record is updated on both databases, I have to be able to prioritize one of updates over the other.
One of the databases is always online and the other one is never online and only has access to local network of organization, synchronization happens everyday at a specific time by downloading all files from internet and uploading them on local net and reverse.
I have considered merge replication and trigger-based replication, but I'm open to any other solutions.
I can't choose the best solution for this task, I really appreciate your advice.
Asked by hanie
(101 rep)
Mar 9, 2024, 08:18 AM
Last activity: May 9, 2025, 11:01 AM
Last activity: May 9, 2025, 11:01 AM