Convert Clipper 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 Clipper . 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:

autoincrement
bigint
blob
image
currency
decimal(19,2)
date
datetime
double
float
float
real
integer
int
logical
bit
numeric
decimal
text
ntext
timestamp
datetime
varbinary
image (if precision > 8000)

Full Convert migration in 4 easy steps

Step 1

Clipper

We will choose dBase and FoxPro (DBF) from the list of available database formats. Both dBase and FoxPro use DBF file format for their database table files. Just type-in the folder containing your dBase database tables, or click the ellipsis button on the right and Full Convert will display Browse for Folder dialog.

Clipper-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.