Subject Re: Remote access to a dBase database living on a private server from
From Akshat Kapoor <akshat.kapoor@kapoorsons.in>
Date Wed, 9 Dec 2020 12:33:01 +0530
Newsgroups dbase.getting-started


> Oh and I almost forgot - if I am going to link it to another SQL db, anyone knows which one integrates better?
>
> MySQL? Mariadb? Postgres? Requirements allow for any of those, the main requirements as to which one I will connect to at the other end will actually be how well it integrates with the dBase module.

Good Morning Franck,

I have personal experience with MariaDB, MySQL would not be very
different. Postgres there would be very few users who would be able to
help you out.

So my vote will go to MariDB.

Regardless of the version of dbf if you are using dbase and exporting
data to MariaDB you should not be requiring any odbc for dbf files. You
will only be requiring ODBC for MariaDB.

Once data is on MariaDB then accessing it remotely is not my field. But
knowing the scale of usage of these engines should not be difficult.

There is a product by dBase dbf export I think.

It can be used to transfer data. No need to learn dBase.

And IF it can run on pre configured auto mode. Then you will only need
to configure it once and all the data would be in MariaDB or MySQL and
from there you can take it forward.

I have never used these products and hence cannot say about them.

The product is dbfExport3
http://www.dbase.com/dbfutilities/

OR
http://www.dbase.com/sqlutilities/


Regards
Akshat