Assume a server in the corporate office with Sql Server 2008.
Offices all over the country, connected to corporate on a VPN.
VFP program, currently with data in Fox, which has data to be sent to corporate once a day. Framework handles remote views very well, very comfortable doing them. Framework has a connection manager, so each office will open only one connection to server.
How would I want to work the licensing on the SQL Server. Offices can stagger times for update, full update procedure should take no more than 5-10 minues. No need for a full-time connection. 100 or more field offices.
Future design involves converting backend in the field to local SQL Express 2008 databases. What would be my options in that case for connecting to and updating to and from corporate server using SQL Server services?
Thoughts?
TIA
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.