Withdata Software

Convert Azure To FoxBase

Want to convert data from Azure to FoxBase?

Try Withdata DBCopier, a Azure to FoxBase converter for Windows, Mac, and Linux, Convert Azure to FoxBase, Easy and Fast.

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

Convert data from Azure to FoxBase

Login to Azure and FoxBase -> Select source Azure tables -> Set target FoxBase tables -> Convert Azure to FoxBase

Choose source Azure database and logon.

Choose target FoxBase database and logon.

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

then show the wizard.

1. Open source Azure.

2. List target FoxBase tables.

3. Select FoxBase tables to import.

4. Convert data from Azure to FoxBase.


More about Azure to FoxBase converter

See also:

Azure SQL → FoxBase reference

Type mapping

Value kindin Azure SQLin FoxBase
IntintNumeric(10,0)
BigintbigintNumeric(19,0)
Decimaldecimal(p,s)Numeric(p,s)
FloatfloatFloat
Textnvarchar(n)Character(n)
Long textnvarchar(max)Memo
DatedateDate
Datetimedatetime2(none)
Binaryvarbinary(max)(none)
BooleanbitLogical
JSONnvarchar(max)(none)

Dialect differences

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

Propertyin Azure SQLin FoxBase
port1433(file-based)
identifiers[square brackets]—
row limitSELECT TOP n(driver dependent)
datesdatetime2, date, timeDate (D)
long textnvarchar(max)Memo (M)
binaryvarbinary(max)—

Command line

SideCommand
Azure SQLbcp
Azure SQL (load)bcp, or BULK INSERT

No counterpart

  • Azure SQL values of kind Date and time have nowhere to go in FoxBase.
  • Azure SQL values of kind Binary have nowhere to go in FoxBase.
  • Azure SQL values of kind JSON have nowhere to go in FoxBase.

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.