Expert Visual FoxPro consulting, maintenance, modernization and migration planning. Support for legacy FoxPro applications, SQL Server integration, 32-bit and 64-bit environments.2026-10-06T03:09:28+00:00

·· HISTORY ··

FoxPro

A procedural programming platform and database management system (DBMS), originally created by Fox Software and later adopted by Microsoft. The final published release of FoxPro was 2.6. Subsequently, development continued under the Visual FoxPro label. FoxPro was derived from FoxBase (by Fox Software), which was in turn derived from dBase III (by Ashton Tate).

After acquiring Fox Software in 1992, Microsoft supported FoxPro until 2015.

Visual FoxPro

A data-centric, object-oriented platform created by Microsoft. It contained the fastest database engine available at the time. Fox Technologies merged with Microsoft in 1992, after which the software acquired further features, plus the prefix “Visual”. Visual FoxPro 3.0, the first “Visual” version, reduced platform support to only Mac and Windows, and later versions 5, 6, 7, 8 & 9 were supported by Windows only. The current Visual FoxPro is COM-based: version 9.0 was released in 2004 and updated in 2007 as the final version of the product.

End of Support

In March 2007, Microsoft announced that there would be no VFP 10, making Visual FoxPro 9 (released in December 2004) the last commercial VFP release. The support of Version 9 continued with service packs and hotfixes that were released in 2005, 2007, 2008, and finally in 2009. In January 2010, mainstream support from Microsoft for VFP ended.

Extended support from Microsoft was available until January 2015 via the developer tools life‐cycle support plan.

··· ANATOMY ···

After 29 years of working on dozens of FoxPro apps for clients of all sizes, I’ve noticed a similar pattern over and over:
  • The client has one large VFP application – 150K to 1M lines of code, 100+ native and/or SQL/Oracle tables, dozens of forms and classes, 100+ reports
  • The app core was initially created by one person about 20-25 years ago – who was its driving force, but since has moved elsewhere
  • The app was gradually upgraded through multiple FoxPro/VFP versions and now resides in VFP 6, 7, 8 or 9
  • The app usually connects to MS SQL or Oracle, despite its native tables
  • The app has hundreds or thousands of in-house/external users
  • No one particular person is familiar all of the app’s business logic
  • The app has been updated, maintained, and fixed by a number of employees and consultants over the years
  • The app still looks like it was made in 1997
  • The app is very poorly documented or not documented at all
  • The code comments are sporadic at best
  • The client has attempted to migrate from VFP at least once, using local or offshore resources, and is still in the middle of the migration or has failed

··· CHALLENGES ···

So, why is it so hard to migrate from FoxPro? Well, FoxPro is a database-oriented Rapid Application Development (RAD) platform, so the nature of its code is quite specific and is unlike anything else. Below are the two most popular migration approaches:
Approach #1: Gathering specs from code
  • Front-end, back-end, business logic and reports are all part of one system. Even though the code is broken into logical blocks – it is also intertwined between different layers of the application, which allows for rapid development
  • Due to rapid development nature of FoxPro, the application grows to very large proportions quickly and without proper design/planning
  • Due to mixture of layers it is very hard to extract business logic from the code and stored procedures (if SQL/Oracle is involved)
  • Since FoxPro is a database-oriented language, data calls / processing (native or external) are present in about every procedure, function and method, making it near impossible to move it into a separate layer
  • FoxPro frameworks (e.g. Visual FoxExpress, Visual Extend, Visual ProMatrix or in-house) are very popular. Frameworks add an extra layer of complexity to the application.
  • It becomes increasingly difficult to locate qualified FoxPro developers, as over 99% have retired or moved on 
Approach #2: Gathering specs from users
  • Users possess knowledge within their specific areas of the application. There’s a very small chance that there is a “superuser” that knows the whole system inside and out. The application is simply too vast.
  • The only “superuser” would be the application creator, but he has likely moved on and is not currently reachable on a full-time basis. Even if the application creator would be available, he would not know all the new features added to the application over the years.
  • A FoxPro BA analyzing the app would have hard time representing the business logic/process workflow in some “pseudo-language”, as that code would resemble FoxPro code one-to-one. That would beg the question – why write specifications at all?
  • Using workflow diagrams to document business logic/processes would be very time consuming and fruitless as well – due to complexity. It would create more confusion and questions than anything else.
Even if business logic is somehow collected and/or extracted from code, the client would still have to redesign the whole app: front-end, reports, and possibly the back-end (with the exception of where most of the data has already been moved to SQL/Oracle). The front end is always highly outdated and sometimes inconsistent, as many developers “enhanced” it over the years without a coherent plan. The reports are limited by the capabilities of FoxPro’s own built-in viewer.

··· WHY MIGRATE? ···

FoxPro offers lots of advantages – however, in the modern world, it also lacks some potentially crucial features:
  • One FoxPro developer can handle front-end, back-end and reporting from the same IDE. No need to get front-end, back-end and design teams involved. This is a great cost saver for maintenance and enhancements
  • Users experience fast (“snappy”) interface, since FoxPro programs are always desktop (not web), highly-integrated applications
  • Visual FoxPro offers ultra-fast database engine with Rushmore optimization and aggressive usage of cache – one of the best on the market, even today. All the SQL, XML and text IO data processing are done blazingly fast. Moreover, VFP can handle very large databases
  • VFP apps can relatively easily handle hundreds of users simultaneously
  • FoxPro apps are highly portable – the installation just needs an executable and basic DLLs
  • FoxPro apps could be distributed free of charge
  • No official support from Microsoft as of 2015
  • Uncertainty of VFP functionality in the future
  • The inability of VFP to work natively on 64-bit OS (without recompiling its kernel)
  • Inability of VFP working on the web natively. There are many techniques to “webify” VFP, but none of them are straightforward or effective
  • Lack of mobile app development platform (e.g. for iOS/Android)
  • Highly outdated user interface
  • Lack of enterprise-level security and scalability

··· SERVICES ···

Poorly planned FoxPro migrations frequently exceed their original budgets, disrupt operations, and still fail to reproduce essential business functionality. My role is to identify those risks early and create a practical, staged strategy based on your actual application.
All the work will be performed remotely, so I would need full access to your application. We can sign an NDA (Non-Disclosure Agreement). Whether it takes me 10, 100, or 1,000 hours to get your company on the right track, I charge a professional rate of $175/hr. My services are in high demand, so I can provide consultations in accordance with my current bandwidth. I will outline my current availability prior to commencing. Below are some highlights of my services:
  • Provide a comprehensive report with a detailed analysis of all FoxPro assets (e.g. databases/tables, forms, classes, reports, etc.) for your company’s application
  • Provide a comprehensive report with a detailed analysis of all non-FoxPro technologies (e.g. frameworks, libraries, ActiveX controls, etc.) that work in conjunction with FoxPro to make your application run
  • Identify all the weak points, challenges, and potential issues in the migration of your FoxPro application
  • Identify the right technologies to migrate to in terms of front-end, back-end, reporting, and all required middle layers that make the most sense for your business (e.g. VS or Xamarin or Appcelerator? .Net or Python or Java? MS Dynamics or SAP? Telerik or Infragistics? MS SQL or Oracle? HTML/CSS/JavaScript? iOS/Android? SSRS? etc.)
  • Identify the necessary project management, business analysis, design, development, and quality assurance human resources for the most streamlined and cost-efficient migration of your application

Pro Rate

$175/hr

··· ABOUT ···

Timothy J. Maxwell
FoxPro Guru
I am a senior software developer and consultant with more than three decades of programming experience, including nearly 30 years working with FoxPro and Visual FoxPro systems.
I help organizations maintain, stabilize, modernize and migrate business-critical FoxPro applications. My experience covers application architecture, business-rule discovery, SQL Server integration, performance optimization, specifications, development, testing and migration oversight.
Because I understand both the technical and business sides of legacy modernization, I can quickly identify risk, distinguish necessary work from unnecessary redevelopment, and recommend a practical path forward.

··· CLIENTS ···

Over the years, I have consulted for dozens of companies of all sizes (from 12 to nearly 300,000 employees) in many industries. Most clients, interestingly, have been in either the financial or healthcare field. I think that’s because FoxPro is particularly well suited for those business sectors. Some of my recent clients are shown below:

··· FAQ ···

I’ve been often asked to talk or write about the future of FoxPro. Below are some of the most frequently asked questions I receive:
Q. Is there an easy way to ballpark a budget for a FoxPro migration?2017-03-06T14:49:17+00:00

A. It depends on a number of factors. However, one very rough rule of thumb would be – $10/line of code. So, an 300,000 line (PRGs, SCXs & VCXs) app would cost approximately $3.0 million (including testing & UAT). However, this implies great planning and near perfect execution.

Q. Can’t we just buy some off-the-shelf software product and customize it to do what our FoxPro application does ?2017-03-06T14:46:50+00:00

A. No. All major FoxPro applications are extremely custom. I’ve never seen a replacement software that would offer more than 30% of required functionality, which would make it completely unusable.

Q. Can’t we just auto-convert our application using tools (e.g. vfp2Servoy, FoxInCloud, etc.)?2017-03-06T14:39:34+00:00

A. No. While you might be able to convert some forms / reports, the functionality will not be converted properly, interface will still look outdated and you’ll end up in a technology that wouldn’t bring any benefits anyway.

Q. Will our FoxPro application just stop working at some point?2017-03-06T14:25:16+00:00

A. No. As long as you keep upgrading your hardware and software, but the Windows OS version on your PCs is still fully compatible with the 32-bit applications, your FoxPro program should function fine (with minor exceptions).

Q. Are there any issues of running VFP on latest Windows 10?2017-03-05T06:33:30+00:00

A. No issues for the most part. I’ve run a lot of tests and the only potential issues could be some printing problems, third-party DLL registrations and other quite rare cases.

Q. Can VFP work on a 64-bit only OS in the future?2017-03-05T06:35:11+00:00

A. Yes, using Chinese unofficial C++ compiled 64-bit VFP “version 10” kernel.

Q. Can VFP be installed on Windows Server 2016?2017-03-04T12:29:43+00:00

A. Yes, utilizing a special technique.

··· PARTNERS ···

In September 2018, we have partnered with Macrosoft Inc – a leader in Visual FoxPro migrations. Now we can handle migrations of any size.

Macrosoft is an ISO 9001:2015 certified software design, development, and consulting company based out of Parsippany, NJ. They have a powerful combination of 25 years of business experience and cutting-edge technological expertise that provides clients with best-in-class solutions in software development projects. Macrosoft specializes in Migration Services and has developed a unique migration methodology along with homegrown automation tools coupled with an ironclad testing process. Macrosoft currently has over 350 technical employees worldwide and has had a Microsoft Gold Partner designation for software development for over 10 consecutive years.

··· CONTACT ···

Please fill out the form below and submit a request and I will get back to you shortly:

    .

    Timothy Maxwell / FoxPro Guru

    500 E. Ridgewood Ave., Suite 23
    Ridgewood, NJ 07450
    United States

    .

    Copyright (C) 1994-2026 by FoxPro Guru. All rights reserved.
    Go to Top