Current I have a replicated db with each user have a Front end and a replicated backend. This allows the user when disconnected to work on their database replicas, but more importantly it allows offsite users to synchronize through a vpn. The VPN is to slow for them to connect directly to the backend (master) on our server. This works fine (actually better than I would have thought).
So my question is can I have users in the office point their front ends directly to the db master on the local server and not use a local replica on their machine? They then would never have to worry about synchronizing. The offsite user would then use replicas and synchronize like they currently do. This reduces the amount of synchronization and for the people in the office it makes keeping data current a lot easier. I ran a test on my machine where I was linked directly to the Master and still was able to synchronize from another machine (I did not think that would work, but it did). Is this a good idea or bad idea? Anyone have experience in this area?
So my question is can I have users in the office point their front ends directly to the db master on the local server and not use a local replica on their machine? They then would never have to worry about synchronizing. The offsite user would then use replicas and synchronize like they currently do. This reduces the amount of synchronization and for the people in the office it makes keeping data current a lot easier. I ran a test on my machine where I was linked directly to the Master and still was able to synchronize from another machine (I did not think that would work, but it did). Is this a good idea or bad idea? Anyone have experience in this area?
