Withdata Software

Migrate Oracle to SQL Server

Want to migrate from Oracle to SQL Server ?

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

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

Choose source Oracle 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 Oracle.

2. Set “Import Type”.

3. Select SQL Server tables to migrate.

4. Migrate from Oracle to SQL Server.

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

More about Oracle to SQL Server converter

See also:

Oracle → SQL Server reference

Type mapping

Value kindin Oraclein SQL Server
IntNUMBER(10)int
BigintNUMBER(19)bigint
DecimalNUMBER(p,s)decimal(p,s)
FloatBINARY_DOUBLEfloat
TextVARCHAR2(n)nvarchar(n)
Long textCLOBnvarchar(max)
DateDATEdate
DatetimeTIMESTAMPdatetime2
BinaryBLOBvarbinary(max)
BooleanNUMBER(1)bit

Dialect differences

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

Propertyin Oraclein SQL Server
port15211433
identifiers"double quotes"[square brackets]
row limitFETCH FIRST n ROWS ONLYSELECT TOP n
datesDATE, TIMESTAMPdatetime, datetime2, date, time
long textCLOB, NCLOBnvarchar(max)
binaryBLOB, BFILEvarbinary(max)

Command line

SideCommand
Oracleexp / expdp
SQL Serverbcp
SQL Server (load)bcp, or BULK INSERT
Oracle (load)sqlldr (SQL*Loader)

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.