I need to send data for my Geobank Mobile database from the local core shack SQL server to the main SQL server in the office. What algorithm would you recommend: log shipping or replication? It seems like replication can be quite challenging to set up and maintain… besides, I know that log shipping is working at least for one of my colleagues at many sites. But are there any hidden problems?
- 4 logging laptops are synchronizing logging data to the SQL GBM database at the local server
- New data is being pushed to the copy of the GBM database on the main SQL server in the office
- An SQL script populates data from GBM views to the buffer table of the main SQL database (GB)
Thanks in advance,
Customer support service by UserEcho