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?
FiveTech Support Forums
FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Migration to web
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
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
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,
Dear Antonio,
Thank you! Does ADORDD work with Harbour?
Sincerely,
yes, of course
please email Antonio Ferreira for AdoRdd help:
antonio-ferreira@m-homem-ferreira.pt
Antonio will provide you the best help for AdoRdd
Thank you Antonio
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?
I agree.
EMG
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.
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.
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"
A great finding that opens many new possibilities
Hello Antonio,
The URL within that topic did not work for me.
It is working fine from here, please try it again