Page 1 of 4

Dbf/cdx to sql changing

Posted: Fri Jul 12, 2024 12:50 pm
by wartiaga
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.

Re: Dbf/cdx to sql changing

Posted: Fri Jul 12, 2024 1:29 pm
by nageswaragunupudi
native mariadb fivewin?
The Best

Re: Dbf/cdx to sql changing

Posted: Fri Jul 12, 2024 2:00 pm
by karinha

Re: Dbf/cdx to sql changing

Posted: Fri Jul 12, 2024 2:18 pm
by RAMESHBABU
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

Re: Dbf/cdx to sql changing

Posted: Fri Jul 12, 2024 2:28 pm
by vilian
I'm also recommend you to use the Fivewin's MariaDb functionality.

Re: Dbf/cdx to sql changing

Posted: Fri Jul 12, 2024 2:29 pm
by Rick Lipkin
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

Re: Dbf/cdx to sql changing

Posted: Fri Jul 12, 2024 2:34 pm
by wartiaga
nageswaragunupudi wrote:
native mariadb fivewin?
The Best
Thank you Mr. Nages

From which version of fivewin mariadb is it functional for my purpose?

Re: Dbf/cdx to sql changing

Posted: Fri Jul 12, 2024 2:35 pm
by wartiaga

Re: Dbf/cdx to sql changing

Posted: Fri Jul 12, 2024 2:35 pm
by wartiaga
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!

Re: Dbf/cdx to sql changing

Posted: Fri Jul 12, 2024 2:36 pm
by wartiaga
vilian wrote:I'm also recommend you to use the Fivewin's MariaDb functionality.
Thank you Vilian! I will try.

Re: Dbf/cdx to sql changing

Posted: Fri Jul 12, 2024 2:37 pm
by wartiaga
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!

Re: Dbf/cdx to sql changing

Posted: Sun Jul 14, 2024 9:54 am
by Otto
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

Re: Dbf/cdx to sql changing

Posted: Sun Jul 14, 2024 10:00 am
by Antonio Linares

Re: Dbf/cdx to sql changing

Posted: Mon Jul 15, 2024 7:33 am
by Otto
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

Re: Dbf/cdx to sql changing

Posted: Mon Jul 15, 2024 12:27 pm
by Uwe.Diemer
II also want to change from Ads to MariaDb im using xHarbour should i change to Harbour ?

r´tx