>>>>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?

They've had a free version for years, so I'm willing to take that risk.