Convert Oracle RDB to SQL CE

Full Convert is designed for ease of use and reliability. Get the migration done quickly and simply, without surprises.

FC-Tutorial-Shape

Making migration easy for you

Full Convert is a fully self-tuning software. Your migration will work as expected without you needing to adjust anything.

Data types are different in SQL CE compared to Oracle RDB . We automatically adjust them as we copy the tables so you don't have to worry about it. You can adjust the mapping rules if you wish to change the following defaults:

binary_double
float
binary_float
real
blob
image
clob
ntext
date
datetime
float
real
long
ntext
long raw
image
nchar
ntext (if precision > 4000)
nclob
ntext
number
decimal
nvarchar2
ntext (if precision > 4000)
raw
varbinary (if precision <= 8000)
raw
image (if precision > 8000)
rowid
nchar(16)
sdo_geometry
ntext
timestamp
datetime
urowid
nchar(16)
xmltype
ntext

Full Convert migration in 4 easy steps

Step 1

Oracle RDB

We will select Oracle RDB from the drop down and fill out the connection parameters.

Oracle RDB-illustration
SQL CE-illustration
Step 2

SQL CE

We will choose SQL Server Compact Edition from the list of available source database engines. Connecting to SQL CE database is straightforward - we need to type-in or navigate to the database file (SQLCE databases are stored in SDF files) and specify our password, if the database is protected.

Step 3

Start the conversion

All source tables are selected for conversion by default. In case you only need some tables, simply deselect the ones you don't need - or deselect all, then select just the tables you do need. Click the Copy your database button to get started.

Click the Copy your database button to get started.

project-overview-illustration
copying-data-illustration
Step 4

Conversion

Conversion is highly-optimized to run as fast as possible, yet provides top-notch reliability. Huge tables are converted in small chunks at a time, preserving memory and ensuring that your computer stays fast and responsive.

Data is now in the target database

Use our built-in database browser to examine the copied data.

target-database-browser-illustration

Of course, you can also examine the conversion in detail and see in-depth information for each table.