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