Paradox Community

Items in pnews.paradox-client_server

Subject:Migrating to MySQL
Date:3 Dec 2020 13:10:10 -0400
From:"pascal hutton" <pascal.hutton@secuspm.com>
Newsgroups:pnews.paradox-client_server

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 ;)


Copyright © 2004 thedbcommunity.com