Convert Acces Database to SqlCE

[dev-studio]

Hi to all.

I would like to build a CF application that works on a database but I need
to convert an Access database to SqlCE.

It's not necessary for me to perform this conversion on the device; I can do
by using a PC application, if available.

Any suggestion ? Thank you in advance.

Regards

dev-studio

 

[Christian Resma Helle]

Hi,

João Paulo Figueira (Primeworks) has a commercial tool called the Data Port
Wizard that can "make full copies of your Microsoft Access or Microsoft SQL
Server databases into SQL Server Compact Edition, SQL Mobile and SQL CE 2.0
databases - and back.."

Try it out, it might do the trick for you. Here is a link:
http://www.primeworks-mobile.com/Products/DataPortWizard.html

 

[Pete Vickers]

Hi,
RemoteSQLCe from our site (www.gui-innovations.com) will do the job

Pete

 

[William LaMartin]

You can write your own conversion program.: Create an empty SqlCe database.
Then for a table in your Access database, create a Table in the SQLCe
database that has the same fields as the Access Table--and here is where you
have to decide what data types in Access are mapped to what data types in
SQLCE. After you have the fields of the SQLCE table defined, you can then
copy the data from the Access Table to the SQLCe table. Do that for each
table. I never looked at creating Queries to match the Queries in the
Access database.