Copy Visual FoxPro table data to SQL Server

Want to transfer data from Visual FoxPro table to SQL Server ?

Try Withdata DBCopier, a Visual FoxPro to SQL Server converter for Windows, Mac, and Linux, Copy Visual FoxPro data to SQL Server, 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

Transfer data from Visual FoxPro table To SQL Server table

Login to Visual FoxPro and SQL Server -> Choose source Visual FoxPro table -> Set target SQL Server table -> Copy Visual FoxPro data to SQL Server

convert Visual FoxPro data to SQL Server data - Choose Visual FoxPro and logon

Choose target SQL Server database and logon.

convert Visual FoxPro data to SQL Server data - Choose SQL Server and logon

Click “Convert From Table” at task dialog.

Import data from Visual FoxPro table to SQL Server table - Task Window

then show the wizard.

1. Open a source Visual FoxPro table.

Convert data from Visual FoxPro table to SQL Server table - Open Source

2. Select a destination SQL Server table and config fields.

Extract Visual FoxPro table data to SQL Server table - select table

3. Preview data.

Migrage data from Visual FoxPro table to SQL Server table - preview

4. Import Visual FoxPro data to SQL Server.

Import data from Visual FoxPro table to SQL Server table - import

More about Visual FoxPro to SQL Server converter

Download Withdata DBCopier

Visual FoxPro → SQL Server reference

Type mapping

Value kind	in Visual FoxPro	in SQL Server
Int	`Numeric(10,0)`	`int`
Bigint	`Numeric(19,0)`	`bigint`
Decimal	`Numeric(p,s)`	`decimal(p,s)`
Float	`Float`	`float`
Text	`Character(n)`	`nvarchar(n)`
Long text	`Memo`	`nvarchar(max)`
Date	`Date`	`date`
Datetime	`DateTime`	`datetime2`
Binary	`General`	`varbinary(max)`
Boolean	`Logical`	`bit`
JSON	`(none)`	`nvarchar(max)`

Dialect differences

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

Property	in Visual FoxPro	in SQL Server
port	`(file-based)`	`1433`
identifiers	`—`	`[square brackets]`
row limit	`(driver dependent)`	`SELECT TOP n`
dates	`Date (D), DateTime (T)`	`datetime, datetime2, date, time`
long text	`Memo (M)`	`nvarchar(max)`
binary	`General (G)`	`varbinary(max)`

Command line

Side	Command
SQL Server	`bcp`
SQL Server (load)	`bcp, or BULK INSERT`

No counterpart

SQL Server 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.