By Joe Rafanelli | May 13th, 2020 |
As a Technical Account Manager, dealing with a variety of different migration questions or concerns are my specialty. Typically, the first question I get is, “how much is this migration going to cost”. This is a great question and is important, but it’s not as big as the timing piece of the migration concern. We live in a “have it now” world that often skews the reality of a multi release and phased projects such as FoxPro migrations. Depending on the number of Lines of Code, Forms, PRG’s, Classes, Reports and DBF’s an application migration can take a considerable amount of time. This factored with how the legacy code is written, can add up to a considerable amount of time. Although there is no “easy button” to an application transformation, there are proprietary tools to help minimize the duration.
Consider the following time saving utilities:
1. Code Matrix – This tool analyzes the VFP application’s project file and its folders to provide an automated count of the inventory (i.e. Forms/Classes/Reports and Program files). It includes counts of Objects, Methods, Procedures, Functions, Comment lines, Database Containers and lines of code. The automation identifies each and every module used in application and count correct number of lines and other object that are considered in migration. The tool intelligently counts only the lines of code to be considered, it counts comments and blank lines separately. This saves the developer a lot of time by not manually tallying all folders and contents within them. Using this tool provides important size information and helps scope-out the entire transformation project.
2. Spec Generator – This tool analyzes the VFP Forms, program files and classes to generate detail technical specification documentation. It generates a separate Word document for each module like forms and program files. Documentation form contains all DBFs being used in it, controls and their locations and events. Documentation also contains easy to understand pseudocode for VFP code. This tool allows the developer to save time by having the code displayed in a readable/workable document ready for either a migration or application re-write. The tech specs generated include the following information:
3. Data Morph – This tool analyzes the VFP Tables and Data to transform into SQL Server. This is a big time saver by automating the Data base conversion. Without this tool, the developer would have to manually complete all of the below steps. The tool is not limited to SQL Server only, it can migrate VFP database to MySQL, PostgreSQL and MongoDB as well.
The Table structure Transformation includes:
The Data Transformation includes:
4. Code Morph – This tool is a Code Parser that reads, analyzes, processes, executes and translates the structured code into a dot net platform. With the use of this tool, the developer will not be required to manually translate the code and framework into dot net and C# code. The tool migrates the VFP application to Macrosoft’s Dazzle framework which comprise of all modern, standard and proved for robust performance components. The tool ensures that no VFP code is left behind. This utility saves an unsurmountable amount of time while increasing the accuracy. The list of automated features is below:
From past experience, I can say with 100% certainty, that clients want ready to go technology. Whether it’s a preferred framework (like Angular JS) or tools that will achieve accurate results more quickly, clients crave speedy platform modernization. Understanding the duration is a key step to transforming a VFP application into the 21 century. An experienced migration partner will help to ensure a seamless migration of your legacy application, keeping zero downtime without any business disruption. A migration can seem like a complicated business – but it’s one that’s made much more comfortable if the right strategy and planning is done in the initial phase. Macrosoft’s migration experts can assist you and your business in making the right choice for your business-critical legacy application