I got pointed to this link
http://www.easysql4fox.vallmind.com/EasySQL4Fox.html which seems to offer some help in converting VFP to SQL backend.
>First of all, thanks to everybody for their responses.
>
>I had not been considering SQL Server (or SQL Server Express) mainly because, well, I did not know enough to consider it.. As it happens, to nobody's surprise, we are running SQL Server, but at this time I have read-only access.
>
>I have noted with interest the discussion and SQL Server Express, and am not at all concerned, for one thing, about the database size. This project is quite small, even by the standards here at Kong, where the entire VFP universe, all in free tables, probably does not at up to 2 Gig. I wouldn't be surprised if this project never gives to 50 Meg total.
>
>So, I could install SQL Server Express locally, create the project, and then eventually (after I've gotten full access) make it available to my client (uh, my employer) for them in SQL Server.
>
>Assuming I'm not interested in scalability or portability, why would I want to go this route?
>
>>>Can somebody supply some recommendations, with both advantages and disadvantages, about using DBCs?
>>>
>>>I have never used a DBC, but am starting a new project of some size and would like to at least consider whether this is the time to start dong so.
>>>
>>>Thanks in advance
>>
>>Is there some reason you are not considering SQL Server instead? There's a free version which will handle moderate sized apps. And if your target is corporate, you won't be laughed out of the room for suggesting a toy database like you will with FoxPro.
If it's not broken, fix it until it is.
My Blog