Absolutely MSSQL. SQL Express is free and quite capable and it is exactly the same code and data files for those places needing full SQL Server Enterprise. When you convert your VFP data look into Fullcontact - the best tool I have found for migrating Fox data to SQL. ( IMO all VFP should be written against SQL backends now )
>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.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
