I'm currently converting to Postgresql.  There are ODBC drivers for both 
MySql and Postgresql for Windows.  They work fine.
Here is what I used for MySQL http://www.dbasehost.com/tutorials/mysql3.php
Make sure to use the 32 bit version of the driver AND Windows ODBC tool.
C:\Windows\SysWOW64\Odbcad32.exe

On 12/3/2020 11:10 AM, pascal hutton wrote:
> Hi,
> After more than 20 years using Paradox i need to move all my paradox datas
> to MySQL (or other database).
> 
> I don't make so much coding anymore (more into management and admin stuff)
> 
> The fun part : All the tables are on a win2012 datacenter VM, all the clients
> (70) are running P7 on WinXP VMs. All this package is running on a Windows
> 2012R2 Hyper-V Cluster (4 nodes) and storage is attached via iscsi on 4 StoreVirtual.
> We have some MySQL Virtual servers running for other stuff.
> 
> The hard part :
> We have almost 1000 tables to convert to MySQL .... the biggest table got
> 1 600 000 records.
> Forms : 1000
> Scripts : 350
> Library : 60
> Reports : 900
> Queries : 800
> 
> Of course we have queries in some scripts, libraries, forms (wouldn't be
> funny)
> 
> The goal is to keep Paradox running as a front-end and then we'll re-write
> all...
> 
> Anyone interested ?
> 
> One of the programmer in my team is doing some testing to write a script
> to create the table and injecting the data from Paradox to MySQL.
> 
> I've searched a bit to find documentation to make P7 connect to MySQL without
> success.
> 
> If somebody has documentation or experience in that process i would be happy
> to know about it.
> 
> You can reach me by mail if you want
> 
> Thanks in advance
> 
> pascal - :-)PH(-: for those who were there long time ago ;)
> 

-- 
Mark Bannister
256-509-2052