Withdata Software

Migrate Access to SQL Server

Want to migrate from Access to SQL Server ?

Try Withdata DBCopier, a Access to SQL Server converter for Windows, Mac, and Linux, Migrate Access to SQL Server, 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

Migrate from Access to SQL Server

Login to Access -> Login to SQL Server -> Select tables to migrate -> Migrate from Access to SQL Server

Choose source Access database and logon.

Choose target SQL Server database and logon.

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

then show the wizard.

1. Open source Access.

2. Set “Import Type”.

3. Select SQL Server tables to migrate.

4. Migrate from Access to SQL Server.

Create SQL Server tables. Copy Access data to SQL Server. Create SQL Server 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 Access to SQL Server?
DBCopier works fast. It convert millions of rows within a minute.
Is it safe to migrate from Access to SQL Server using DBCopier?
Of course! DBCopier migrate from Access to SQL Server locally, absolutely safe.
Can I migrate from Access to SQL Server on Linux, Mac OS?
Yes, you can. DBCopier has Linux, Mac OS, and Windows version.

More about Access to SQL Server converter

See also:

Access → SQL Server reference

Type mapping

Value kindin Accessin SQL Server
IntLong Integerint
BigintLong Integerbigint
DecimalDecimaldecimal(p,s)
FloatDoublefloat
TextText(n)nvarchar(n)
Long textLong Textnvarchar(max)
DateDate/Timedate
DatetimeDate/Timedatetime2
BinaryOLE Objectvarbinary(max)
BooleanYes/Nobit

Dialect differences

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

Propertyin Accessin SQL Server
port(file-based)1433
datesDate/Timedatetime, datetime2, date, time
long textMEMOnvarchar(max)
binaryOLE Objectvarbinary(max)

Command line

SideCommand
SQL Serverbcp
SQL Server (load)bcp, or BULK INSERT

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.