Hi Gary,

One more choice for you to consider. Sybase Sql Anywhere is a very powerful small database that is used extensively as an embedded database for vertical apps. It has a small footprint, very easy to maintain, will run on several platforms including Linux. It does not require a windows server product. It has a .net provider for easy interface to the database. Database can be moved using the copy command. Before I sold my company in 2000, I had over 1000 locations across the US. Support of the database was quite easy.

Sybase has a partner program that will allow you to embed the product into you application. The user doesn't need to know what database you are using. They also have discount pricing for partners depending on how may databases are purchased. One of their big partners is Quick Books.

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