FoxPro Programming
Fastest way to convert free tables to MySQL
Gravatar is a globally recognized avatar based on your email address. Fastest way to convert free tables to MySQL
  Eric Cholis
  All
  Dec 28, 2016 @ 06:07am

I'm looking to convert and regularly syncronize (one-way) some large FoxPro free tables to MySQL or Postgres. Speed and reliability are a must. I've researched a number of tools, even so far as looking at Python with something like asyncpg.

Gravatar is a globally recognized avatar based on your email address. re: Fastest way to convert free tables to MySQL
  Rick Strahl
  Eric Cholis
  Dec 28, 2016 @ 12:24pm

You can always write your own. There's nothing tricky about writing data to MySql over and ODBC connection. Just open connection and INSERT\UPDATE away.

Personally for data access tasks like that I often use business objects (wwBusiness). I load up the data with one connection, and write it with another. That makes the code real simple, but it's definitely not the fastest way of doing this.

+++ Rick ---

Gravatar is a globally recognized avatar based on your email address. re: Fastest way to convert free tables to MySQL
  Eric Cholis
  Rick Strahl
  Dec 28, 2016 @ 12:28pm

Thanks Rick. I've tested that method in both VFP and Python (which as some good DBF packages). Both are too slow to be reasonable.

I'm having some luck with Full Convert and Replicator from Spectal Core.

© 1996-2024