This article was written by one of our resellers that found in Scriptcase what he needed to migrate from visual FOXPRO once it got discontinued by Microsoft.

Migrating Visual FOXPRO To Scriptcase

I have been using Visual Foxpro from its early beginning. That means since 1984, when it was DB II, and then DB III, DB IV, and Fox, and finally Visual Foxpro ending with Last Version 9 on  1997.

Since, VISUAL FOXPRO is not going to have any more releases.  I think the best thing Visual Foxpro developers should do is to move to a new way to develop their  applications, or they are going to get obsolete the same as Visual Foxpro is going to be, on a near future.

The  good news for Visual Foxpro developers is that i find the answer where should we move, and i will help on an easy way how to do it.

First we must move up, that means cloud computing and the answer is SCRIPTCASE,  which is a strong powerful tool  to create the type of applications we used to built on  Visual Foxpro, with the advantage of creating web database driven applications, on a faster, and easier way.

SCRIPTCASE is very easy to use, and also very easy to learn, and you can create a lot of business applications including CRM, and ERP applications.

Here i will explain how to migrate from VISUAL FOXPRO to SCRIPTCASE.

Introduction

First, you must visit www.scriptcase.net and take a look to some videos to get familiar with SCRIPTCASE.

Databases

If you still are using the append blank and replace command on Visual Foxpro, you must forget about that old syntaxis, and move to SQL syntax which is very easy to learn, and they are a lot of books and web pages that may help you for that.

I do recommend to move to MYSQL, because is the one which i have selected and worked, and it is powerful and easy.

Hosting

Due that SCRIPTCASE, is oriented for WEB APPLICATIONS. You must buy a hosting with a database service, if you do not have it already.
I have  bought one on godaddy.com with Mysql and Linux.

Converting Visual FOXPRO DBF Files to MySQL

Here is how to convert them.

USE FILENAME
EXPORT TO NEWFILENAME TYPE CSV

Now the new file you can upload it on the new table with PHPADMIN, with the import option and in a couple of minutes you will have all the visual foxpro tables uploaded, and ready to use.

Now you are almost done, because creating the forms, the grids, the reports, the menus, is much easier and faster, and you are going to find that many applications can be done writing very few lines of code and in many cases without writing even a  single line of code at all.

By ,

December 4, 2012

a

You might also like…

5 reasons you can’t miss a Black Friday Scriptcase!

This November we bring you the biggest and most important discounts of the year! And do you know wh...

Taking a look at Scriptcase version 9.7

After the big Scriptcase 9.7 presentation event, we have a new version of Scriptcase for download, ...

October Newsletter

Follow the latest news for the month of October! Webinars, blog posts, videos, and more. WEB...

You might also like…

Get new posts, resources, offers and more each week.

We will use the information you provide to update you about our Newsletter and Special Offers. You can unsubscribe any time you want by clinck in a link in the footer of any email you receive from us, or by contacting us at sales@scriptcase.net. Learn more about our Privacy Police.