Same Database two different locations.

Anyone know of a way to say have a brick and mortar store with one database and two POS stations on RMS 2.0 and a third mobile laptop with internet access using the same database as the store with the same inventory and customers. Example: Some calls for a service call and you load up two items for the call. Go fix the problem with the two items, then while out in the field you use the laptop to write up and process the order with either an in house account or you take a credit card, check or cash in the field with internet and using the same database as the store's without using HQ. The service truck doesn't keep it's own inventory so I don't need a database on its own. And can we use an Ingenico i6550 on the road over the internet to accept credit cards? Thanks for you time and thoughts. Steve -- Steve

Jeff, Steven can accomplist both by setting up his laptop with RMS and setting his server as his outside IP (Fixed one is recommended!), and opening port 1433 in his router and pointing it to the server. And don't forget to password the datase!!!

Don't open up your SQL Server to the outside world.

Setup a VPN and then connect to your SQL Server.

I would agree with Michael in using a VPN

If you wanted someth> Don't open up your SQL Server to the outside world.