Dbf/cdx to sql changing

Dbf/cdx to sql changing

Postby wartiaga » Fri Jul 12, 2024 12:50 pm

Hi,

I'm thinking about definitely migrating from dbf/cdx to sql. Which of the 3 options would have a shorter learning curve and time and which is fully mature for upgrading large systems that already work with dbf/cdx? sqlrdd, rddsql or native mariadb fivewin?

Thanks in advance.
wartiaga
 
Posts: 208
Joined: Wed May 25, 2016 1:04 am

Re: Dbf/cdx to sql changing

Postby nageswaragunupudi » Fri Jul 12, 2024 1:29 pm

native mariadb fivewin?

The Best
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10595
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: Dbf/cdx to sql changing

Postby karinha » Fri Jul 12, 2024 2:00 pm

João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341
User avatar
karinha
 
Posts: 7766
Joined: Tue Dec 20, 2005 7:36 pm
Location: São Paulo - Brasil

Re: Dbf/cdx to sql changing

Postby RAMESHBABU » Fri Jul 12, 2024 2:18 pm

Hi,

I am almost in the process of concluding the conversion my Very Huge Application
from DBFCDX to FiveWins's Native MariaDb Functionality.

There are several ways provided in MariaDb Class with several Examples
using which you can easily adopt MariaDb.

Please go through the examples provided in the forum, under several threads
with "MariaDb" search.

I strongly recommend you to use the Fivewin's MariaDb functionality.

Thanks to Mr.Nageswara Rao and Mr.Antonio for their great contribution to FiveWinners.

-Ramesh Babu P
User avatar
RAMESHBABU
 
Posts: 624
Joined: Fri Oct 21, 2005 5:54 am
Location: Secunderabad (T.S), India

Re: Dbf/cdx to sql changing

Postby vilian » Fri Jul 12, 2024 2:28 pm

I'm also recommend you to use the Fivewin's MariaDb functionality.
Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Belém-Pa-Brazil
User avatar
vilian
 
Posts: 971
Joined: Wed Nov 09, 2005 2:17 am
Location: Brazil

Re: Dbf/cdx to sql changing

Postby Rick Lipkin » Fri Jul 12, 2024 2:29 pm

To All

There are many options moving dbf to Sql and the ADO Class ... Have a look at the sample AdoRick.prg ( AdoRick.Exe ) .. that can be compiled in this example creating and connecting to ms access,... the example creates its own MS Access database and demonstrates the use of using xBrowse as well as using incremental searches .. can also connect to MS Sql Server and Oracle.

Rick
User avatar
Rick Lipkin
 
Posts: 2662
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA

Re: Dbf/cdx to sql changing

Postby wartiaga » Fri Jul 12, 2024 2:34 pm

nageswaragunupudi wrote:
native mariadb fivewin?

The Best


Thank you Mr. Nages

From which version of fivewin mariadb is it functional for my purpose?
wartiaga
 
Posts: 208
Joined: Wed May 25, 2016 1:04 am

Re: Dbf/cdx to sql changing

Postby wartiaga » Fri Jul 12, 2024 2:35 pm

wartiaga
 
Posts: 208
Joined: Wed May 25, 2016 1:04 am

Re: Dbf/cdx to sql changing

Postby wartiaga » Fri Jul 12, 2024 2:35 pm

RAMESHBABU wrote:Hi,

I am almost in the process of concluding the conversion my Very Huge Application
from DBFCDX to FiveWins's Native MariaDb Functionality.

There are several ways provided in MariaDb Class with several Examples
using which you can easily adopt MariaDb.

Please go through the examples provided in the forum, under several threads
with "MariaDb" search.

I strongly recommend you to use the Fivewin's MariaDb functionality.

Thanks to Mr.Nageswara Rao and Mr.Antonio for their great contribution to FiveWinners.

-Ramesh Babu P


Thank you Ramesh!
wartiaga
 
Posts: 208
Joined: Wed May 25, 2016 1:04 am

Re: Dbf/cdx to sql changing

Postby wartiaga » Fri Jul 12, 2024 2:36 pm

vilian wrote:I'm also recommend you to use the Fivewin's MariaDb functionality.


Thank you Vilian! I will try.
wartiaga
 
Posts: 208
Joined: Wed May 25, 2016 1:04 am

Re: Dbf/cdx to sql changing

Postby wartiaga » Fri Jul 12, 2024 2:37 pm

Rick Lipkin wrote:To All

There are many options moving dbf to Sql and the ADO Class ... Have a look at the sample AdoRick.prg ( AdoRick.Exe ) .. that can be compiled in this example creating and connecting to ms access,... the example creates its own MS Access database and demonstrates the use of using xBrowse as well as using incremental searches .. can also connect to MS Sql Server and Oracle.

Rick


Thank you Rick!
wartiaga
 
Posts: 208
Joined: Wed May 25, 2016 1:04 am

Re: Dbf/cdx to sql changing

Postby Otto » Sun Jul 14, 2024 9:54 am

Hello friends,
A question - we have so many adapters in Fivewin. We can practically connect to all databases.
What we cannot do, however, is access a DBF from a web-hosted website with a low-cost provider.
I think this capability would benefit many who still work with DBF.

I have seen the great interest in this topic in modharbour.club. Here, I think, there would be a market for FIVEWIN to gain new users.
One could then collaborate with young programmers.

Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6301
Joined: Fri Oct 07, 2005 7:07 pm

Re: Dbf/cdx to sql changing

Postby Antonio Linares » Sun Jul 14, 2024 10:00 am

regards, saludos

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

Re: Dbf/cdx to sql changing

Postby Otto » Mon Jul 15, 2024 7:33 am

Dear Antonio,

Thank you.

I hope you’re not still celebrating.

What I don’t quite understand here is how the general HARBOUR functions get to the web server. Do I also need to upload Harbour here, or how does it work?


***


What I mean by PHP access to DBF is, for example, when a FIVEWIN user wants to set up a small homepage for themselves that they can dynamically populate, they have few options to do it quickly.
They need an SQL server, which is associated with extra costs. I think if FIVETECH could offer something for PHP here, there would be a large market for it.
One could then maintain the DBF files offline with FIVEWIN.

Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6301
Joined: Fri Oct 07, 2005 7:07 pm

Re: Dbf/cdx to sql changing

Postby Uwe.Diemer » Mon Jul 15, 2024 12:27 pm

II also want to change from Ads to MariaDb im using xHarbour should i change to Harbour ?

r´tx
User avatar
Uwe.Diemer
 
Posts: 98
Joined: Mon Aug 09, 2010 11:00 am

Next

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 25 guests