Migration to web

Migration to web

Postby dtussman » Mon Aug 06, 2018 10:58 pm

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?
dtussman
 
Posts: 97
Joined: Sat Jun 06, 2015 6:57 pm

Re: Migration to web

Postby Antonio Linares » Tue Aug 07, 2018 7:25 am

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
Antonio Linares
Site Admin
 
Posts: 42149
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: Migration to web

Postby cdmmaui » Wed Aug 08, 2018 8:02 pm

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
cdmmaui
 
Posts: 693
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

Re: Migration to web

Postby Antonio Linares » Thu Aug 09, 2018 1:07 pm

regards, saludos

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

Re: Migration to web

Postby cdmmaui » Thu Aug 09, 2018 1:12 pm

Dear Antonio,

Thank you! Does ADORDD work with Harbour?

Sincerely,
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
cdmmaui
 
Posts: 693
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

Re: Migration to web

Postby Antonio Linares » Thu Aug 09, 2018 1:14 pm

yes, of course
regards, saludos

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

Re: Migration to web

Postby Antonio Linares » Thu Aug 09, 2018 1:21 pm

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
Antonio Linares
Site Admin
 
Posts: 42149
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: Migration to web

Postby cdmmaui » Thu Aug 09, 2018 1:33 pm

Thank you Antonio
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
cdmmaui
 
Posts: 693
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

Re: Migration to web

Postby dtussman » Fri Aug 10, 2018 4:15 pm

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?
dtussman
 
Posts: 97
Joined: Sat Jun 06, 2015 6:57 pm


Re: Migration to web

Postby cdmmaui » Fri Aug 10, 2018 6:16 pm

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
User avatar
cdmmaui
 
Posts: 693
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

Re: Migration to web

Postby dtussman » Sat Aug 11, 2018 3:53 am

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"
dtussman
 
Posts: 97
Joined: Sat Jun 06, 2015 6:57 pm

Re: Migration to web

Postby Antonio Linares » Sat Aug 11, 2018 6:21 am

A great finding that opens many new possibilities :-)

viewtopic.php?p=214165#p214165
regards, saludos

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

Re: Migration to web

Postby cdmmaui » Sat Aug 11, 2018 12:11 pm

Hello Antonio,

The URL within that topic did not work for me.
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
cdmmaui
 
Posts: 693
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

Re: Migration to web

Postby Antonio Linares » Sat Aug 11, 2018 12:43 pm

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

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


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 16 guests