Migrate Visual FoxPro to Percona

Shiji Pan

1 year ago

Want to migrate from Visual FoxPro to Percona?

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

Step by Step, just a few mouse clicks.
Create Percona tables with auto mapping data types. Create Percona indexes.

Download Withdata DBCopier
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Migrate from Visual FoxPro to Percona

Choose source Visual FoxPro database and logon.

Choose target Percona database and logon.

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

then show the wizard.

1. Open source Visual FoxPro.

2. Set “Import Type”.

3. Select Percona tables to migrate.

4. Migrate from Visual FoxPro to Percona.

Create Percona tables. Copy Visual FoxPro data to Percona. Create Percona indexes.

FAQ

What is Withdata DBCopier?

Withdata DBCopier is an on-premise data conversion software that helps you to copy data between databases. Download Withdata DBCopier

How long does it take to migrate from Visual FoxPro to Percona?

DBCopier works fast. It convert millions of rows within a minute.

Is it safe to migrate from Visual FoxPro to Percona using DBCopier?

Of course! DBCopier migrate from Visual FoxPro to Percona locally, absolutely safe.

Can I migrate from Visual FoxPro to Percona on Linux, Mac OS?

Yes, you can. DBCopier has Linux, Mac OS, and Windows version.

More about Visual FoxPro to Percona converter

Download Withdata DBCopier
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Visual FoxPro → Percona reference

Type mapping

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

Dialect differences

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

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

Command line

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

No counterpart

Percona has no equivalent for JSON - it has to be flattened or dropped.

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.