Migration to web

[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?

[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

[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,

[Antonio Linares]

Please read this

https://github.com/AHFERREIRA/adordd/blob/master/01_README.pdf

[cdmmaui]

Dear Antonio,

Thank you! Does ADORDD work with Harbour?

Sincerely,

[Antonio Linares]

yes, of course

[Antonio Linares]

please email Antonio Ferreira for AdoRdd help:

antonio-ferreira@m-homem-ferreira.pt

Antonio will provide you the best help for AdoRdd

[cdmmaui]

Thank you Antonio

[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?

[Enrico Maria Giordano]

I agree.

EMG

[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.

[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"

[Antonio Linares]

A great finding that opens many new possibilities

viewtopic.php?p=214165#p214165

[cdmmaui]

Hello Antonio,

The URL within that topic did not work for me.

[Antonio Linares]

It is working fine from here, please try it again