Migration to web

Post Reply
dtussman
Posts: 78
Joined: Sat Jun 06, 2015 6:57 pm

Migration to web

Post by dtussman »

I have a legacy FWH application consisting of hundreds of thousands of lines of virtually unreadable code using dbf files with about 1000 active installations which I would like to migrate to an SQL web-based application. Is this even practical and if so what is the best way to accomplish this?
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Re: Migration to web

Post by Antonio Linares »

David,

As a first migration step you could use the free ADORDD so you app will start using a SQL database instead of DBFs,
and there is no need to rewrite the app

https://github.com/AHFERREIRA/adordd.git

Full docs in its wiki
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
cdmmaui
Posts: 653
Joined: Fri Oct 28, 2005 9:53 am
Location: The Woodlands - Dallas - Scottsdale - London
Contact:

Re: Migration to web

Post by cdmmaui »

Dear Antonio,

I would love to do this as well and I am in a same situation and I want to leave DBF.

I have a few questions.
1. Is there a tool to migrate data to SQL, specifically MS SQL?
2. You said there are no code changes, so how are APPEND, REPLACE, DELETE handled? Is there a library that automatically replaces the legacy commands with new ones?
3. How are SEEK and FILTER handled?

Sorry for all the questions and also being late to the ADORDD party :-)

If it is that simple, I am really excited to get this going!!!

Sincerely,
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Re: Migration to web

Post by Antonio Linares »

regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
cdmmaui
Posts: 653
Joined: Fri Oct 28, 2005 9:53 am
Location: The Woodlands - Dallas - Scottsdale - London
Contact:

Re: Migration to web

Post by cdmmaui »

Dear Antonio,

Thank you! Does ADORDD work with Harbour?

Sincerely,
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Re: Migration to web

Post by Antonio Linares »

yes, of course
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Re: Migration to web

Post by Antonio Linares »

please email Antonio Ferreira for AdoRdd help:

antonio-ferreira@m-homem-ferreira.pt

Antonio will provide you the best help for AdoRdd
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
cdmmaui
Posts: 653
Joined: Fri Oct 28, 2005 9:53 am
Location: The Woodlands - Dallas - Scottsdale - London
Contact:

Re: Migration to web

Post by cdmmaui »

Thank you Antonio
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
dtussman
Posts: 78
Joined: Sat Jun 06, 2015 6:57 pm

Re: Migration to web

Post by dtussman »

Realistically, is there really any point to converting a large legacy FWH application to SQL files using ADORDD? I have a thousand existing installations using dbf files with zero problems. To move to a web app with an SAS model would really require starting from scratch and doing a complete rewrite, would it not?
User avatar
cdmmaui
Posts: 653
Joined: Fri Oct 28, 2005 9:53 am
Location: The Woodlands - Dallas - Scottsdale - London
Contact:

Re: Migration to web

Post by cdmmaui »

Hello,

We used an old library and combined with xBase++ to create CGI applications that use DBF. Initially we developed on tracking system for our FWH windows based application and it works fine. Yes, we had to create new code (PRG with HTML and CSS). We then got a project in 2015 to develop a specific web based system that would have over 500 users on throughout a business day. We used the same technology and FWH windows applications for backend systems to read EDI messages and post data to the frontend web based system. I have been trying to get xBase++ 2.0 with SQL and the old library but I have not been successful, however I think with a little more time, I will figure it out. In the meantime, we continue to use CGI applications on windows 2012 through 2016. Here are a couple screenshots for your reference.

This integrates outside APIs that include GPS and RFID to name a few.

Image
Image
Image
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
dtussman
Posts: 78
Joined: Sat Jun 06, 2015 6:57 pm

Re: Migration to web

Post by dtussman »

I contacted Alaska software asking about xbase++ 2.0 and what they said was astounding. Yes, they are compatible with clipper code...but only summer 87 through 5.2. Who in the world still uses that? I loved summer 87 but it was DOS so how can DOS summer 87 code possible be made into a windows app without modification. As for Fivewin, they said "sorry"
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Re: Migration to web

Post by Antonio Linares »

A great finding that opens many new possibilities :-)

http://forums.fivetechsupport.com/viewt ... 65#p214165
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
cdmmaui
Posts: 653
Joined: Fri Oct 28, 2005 9:53 am
Location: The Woodlands - Dallas - Scottsdale - London
Contact:

Re: Migration to web

Post by cdmmaui »

Hello Antonio,

The URL within that topic did not work for me.
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Re: Migration to web

Post by Antonio Linares »

It is working fine from here, please try it again
regards, saludos

Antonio Linares
www.fivetechsoft.com
Post Reply