we are about to convert the first of a number of vertical market applications from VFP9 to .Net.

We have 100's of clients, ranging in size from single pc, single user, through large corporation and upto Citrix based WAN networks.
The largest proportion of our clients have between 3 and 5 pc's in either a small server based network or a peer to peer network.

My question is what database to use? Do we stick with VFP data for the smaller sites and use something else for the larger sites? or go for SQL Server across all clients? I have no knowlodge of SQL Server, but many years VFP. Does SQL Server have an advantage over MySQL? or are any of the others a good migration for a VFP knowledgable development team?

Any thoughts?


Gary.