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