You know your situation and experience better that anyone here. If you want to use SQL Server, that is probably what you should use. If you don't want to use VFP to build the middle tier, you probably shouldn't. People tend to work better when they work with the tools they picked.

This is like anything though: Try a few things and see what you like the most initially. Do some test with large data sets and see what works best. Then decide. In four or five hours you can answer your own question and feel comfortable with your decision.

>I will be starting a web business soon. We would be providing some directory services on the long run. I would like to know what do you guys think is the best choice for middle tier and backend database solution.
>
>I am thinking of using SQL server instead of VFP database. Any comment? Also, I am not sure if I should use VFP to build the middle tier. It may not be a good idea to go 2 tier first because we aim for large transactions.