Hi Sherry,
I've used the VFP/SQL Server combo for several years and am totally satified with the performance. As with any new technology, there is a learning curve involved on your part. There is lots of SQL Server info on the UT and on the bookshelves.
It will also open new development opportunities for you. For a simple start you can use stored procedures to offload some of your code to the server or you can go completely wild and start developing n-tier apps! Whatever you choose, you're in for a new, exciting experience. Good Luck.
Bob Tracy
Never engage in a battle of wits if you're only half armed.