Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Administration  Syncing Databases

Author  Topic  HARRYJ68 Starting Member 1 Post Posted - 2014-09-22 : 04:09:08 I'm using a commercial aircraft maintenance software program that uses SQL for the database. I setup a vpn access to our server(fixed IP) so people on our other site can operate the program/connect to our data on the server. The internet connection is far too flakey to make this a viable option, so now we are considering installing SQL Express at the other location, and synching the data overnight. Both sites will be using the program(changing data), so I'm looking at how I can do a 2 way sync each night. I'm using SQL 2014. I'm in Jakarta, Indonesia and our other site is Bandung, so if anyone has a contact in Jakarta to help that will be great! James