Hi, I need 2 MsSQL server instance on 2 different location with syncronized data. Location A is always on. Location B will be on for limited time frames.
*Need 2 SQL server instances.
*Same databases on both instances
*Location A is always on, location B is not.
*When location B is down, location A must continue to work.
*When location B is up, it must be syncronized with location A.
*If I add, update, delete a record on A or B databases, It must be synchronized on both servers.
*Servers are connected by VPN over the internet.
*We will run 2 copies of the same application. Each copy will be connecting to the one location
*No need of load balancing or always-on features.
*We have all required licenses for Microsoft Servers and Microsoft SQL Servers.
17 freelancers are bidding on average $198 for this job
Hello I am expert in net desktop development and also have SQL server and I will be able to finish your work in time and if you are interested working with me and let me know by message thanks kbn
I had Implement Solution for the same project for one of the critical businesses had multi-site with high network latency also some branches stay days without an internet connection.