I'm at a point where I'd like to migrate my application from a local VFP database to a remote database (most likely SQL server) with a multi location setup.
I'd like to get opinions of what type others would recommend to accomplish this most rapidly and easily.

If I were to use remote views to a sql server database, does the remote(over a WAN) transaction work the same as a LAN setup? Is it fast enough to consider?

Allen