>>>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?
>>
>>Almost certainly best to switch the MSSQL. If you're currently using VFP then there's a good chance the SQL Express will be adequate.
>>
>>> 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?
>>
>>For .NET there's a definite advantage with MSSQL - .NET has it's own specific dataprovider for MSSQL and if you can use SQL Express then it's free as well.
>>
>>Downsides are that you will presumably have to migrate everyone's existing data from VFP and install MSSQL on all sites - unless you can use the CE version which is just a couple of DLLs that you can embed into the .NET application.
>>My 10c,
>>Viv
>
>Agreed.

I agree, but what if the free version goes away one day?