Convert Percona To Visual FoxPro

Want to convert data from Percona to Visual FoxPro?

Try Withdata DBCopier, a Percona to Visual FoxPro converter for Windows, Mac, and Linux, Convert Percona to Visual FoxPro, Easy and Fast.

Can run in GUI mode, Step by Step, just a few mouse clicks.
Can run in Command line, for Scheduled Tasks and Streams.
Support Windows, Linux, and macOS.

Download Withdata DBCopier

Convert data from Percona to Visual FoxPro

Login to Percona and Visual FoxPro -> Select source Percona tables -> Set target Visual FoxPro tables -> Convert Percona to Visual FoxPro

Convert data from Percona to Visual FoxPro - Choose Percona and logon

Choose target Visual FoxPro database and logon.

Convert data from Percona to Visual FoxPro - Choose Visual FoxPro and logon

Click “Wizard – Import All Tables” at task dialog.

Convert data from Percona to Visual FoxPro - Task Window

then show the wizard.

1. Open source Percona.

Convert data from Percona to Visual FoxPro - Open source database

2. List target Visual FoxPro tables.

Convert data from Percona to Visual FoxPro - list target tables

3. Select Visual FoxPro tables to import.

Convert data from Percona to Visual FoxPro - select tables

4. Convert data from Percona to Visual FoxPro.

Convert data from Percona to Visual FoxPro - import

More about Percona to Visual FoxPro converter

Download Withdata DBCopier

Percona → Visual FoxPro reference

Type mapping

Value kind	in Percona	in Visual FoxPro
Int	`INT`	`Numeric(10,0)`
Bigint	`BIGINT`	`Numeric(19,0)`
Decimal	`DECIMAL(p,s)`	`Numeric(p,s)`
Float	`DOUBLE`	`Float`
Text	`VARCHAR(n)`	`Character(n)`
Long text	`LONGTEXT`	`Memo`
Date	`DATE`	`Date`
Datetime	`DATETIME`	`DateTime`
Binary	`LONGBLOB`	`General`
Boolean	`TINYINT(1)`	`Logical`
JSON	`JSON`	`(none)`

Dialect differences

Both Percona and Visual FoxPro are database servers, so the differences below are dialect-level: the same concept is spelled differently on each side.

Property	in Percona	in Visual FoxPro
port	`3306`	`(file-based)`
identifiers	`backtick`	`—`
row limit	`LIMIT n`	`(driver dependent)`
dates	`DATETIME, TIMESTAMP, DATE, TIME`	`Date (D), DateTime (T)`
long text	`TINYTEXT / TEXT / MEDIUMTEXT / LONGTEXT`	`Memo (M)`
binary	`BLOB / TINYBLOB / LONGBLOB`	`General (G)`

Command line

Side	Command
Percona	`mysqldump`
Percona (load)	`mysqlimport, or LOAD DATA INFILE`

No counterpart

Percona values of kind JSON have nowhere to go in Visual FoxPro.

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.