Migrate Percona to Visual FoxPro

Shiji Pan

1 year ago

Want to migrate from Percona to Visual FoxPro?

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

Step by Step, just a few mouse clicks.
Create Visual FoxPro tables with auto mapping data types. Create Visual FoxPro 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 Percona to Visual FoxPro

Choose source Percona database and logon.

Choose target Visual FoxPro database and logon.

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

then show the wizard.

1. Open source Percona.

2. Set “Import Type”.

3. Select Visual FoxPro tables to migrate.

4. Migrate from Percona to Visual FoxPro.

Create Visual FoxPro tables. Copy Percona data to Visual FoxPro. Create Visual FoxPro 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 Percona to Visual FoxPro?

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

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

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

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

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

More about Percona to Visual FoxPro 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

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.