The choice is yours, and there are bennifits for each.
Below is what I have found as some of the highlights to consider.

Mssql, offers to the VFP programmer, a much eaiser path to work within. Lots of documentation and samples on how Mssql works with VFP. There are a few books on the market on how to do it, what to watch out for. not to mention there are easy to get ahold of utilities, that migrate vfp tables into sql server.

The main draw back, is the cost...Mssql is not cheep, and to maintain it you might be looking at another person who is certified in MSsql, or at least yourself getting to understand the processof backups etc.

Mysql on the otherhand, has benefits. and drawbacks as well. Here are some thoughts.
Mysql is FAST! over the internet, with a 56K dialup, I can get 50 records into a vfp cursor (customer type records) in under a second.
Mysql as a server, will run on windows, or Linux. So whatever you have a server Mysql will work with it.
ISP's (many of them) offer Mysql as part of their hosting package, where you can rent a web site, that has a Mysql database running already. I have yet to see a MsSql database server avail for lease on the internet, unless you start talking about cohosting, a MSsql server.
The drawbacks to Mysql

There are some features of the Sql Language, which are not supported at this time by MySql, Tranactions, Stored proceedures, and Subqueries. So if you need these type of sql commands to get your application to work right, you might need to look at other SQL servers, MsSql, oracle, or even free ones like Postgresql. so choosing Mysql should be a very careful consideration based on your requirments, as far as the techincal aspects, Both platforms, seem to prerform well over tcp/ip.

Before you decied on on other the other, personally, I would start testing them both, yourself, Get MSDE, (free) and start working with that, and if you dont know have access to a mysql server, or a postrgresql server, log onto www.freesql.org and sign up for one there. Since its free there to test a database server. you will get to know for yourself what your needs are.




>Hello!
>
> Does anyone know which is the best choice between MS SQL Server and
>MySQL? (technical point of view)
>Context:
>- TCP/IP protocol over the network
>- MS Visual FoxPro (5 or 6) as the front end development tool
>
>thank you!