We are in the process of converting from DBF to SQL. This will allow us to continue to use the VFP front end UI until we can convert to .Net.

We are using West-Wind business objects for the middle tier. This allows us to run in DBF mode or SQL mode. In theory you just have to flip a switch to work in either data format but unfortunately there is much more work required, at least in our program.

Kent

-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Tracy Pearson Sent: Saturday, July 23, 2016 9:20 AM To: profox@leafe.com Subject: Re: Going from DBF to SQL in frameworks

These are 2 established programs that were built with the framework. They are separate companies that approached me with the question about converting to an SQL back end. I have not done this.

My request is if someone has done this, I'd like to hear some feedback about the project.

It sounds like both companies will want a rewrite in the future. They are looking for information to know which route to take. Convert to SQL then write new modules, or just rewrite dealing with dbf issues.

Tracy

On July 23, 2016 5:23:17 AM EDT, Man-wai Chang changmw@gmail.com wrote:

If you are fluent with VFP, you might consider building your own SIMPLIFIED framework. Most commercial frameworks are way too complicated.

Commercial frameworks are good if and only if your needs are simple. When you need to do heavy customization, it would be as messy as if there was no framework. :)

On Fri, Jul 22, 2016 at 10:00 PM, Tracy Pearson tracy@powerchurch.com wrote:

...

A couple different projects I know about are looking to convert from

using

...

DBFs to an SQL backend.

One project is using the Visual ProMatrix framework. The other is using Codemine.

-- Sent from my Android device with K-9 Mail. Please excuse my brevity.

[excessive quoting removed by server]