You'd have to write code that queries the contents of the database mdf and
writes to a new database sdf.

Paul T.

Diego,

Here is a 3rd party utiltiy to do this, or you can write your own code:

http://www.primeworks-mobile.com/Products/DataPortWizard.html

You could also use Sync Services for ADO.NET to create a SQL Compact 3.5
database from SQL 2005 tables. Is there a particular reason you are using
SqlCE 3.1 instead of 3.5?

Ginny Caughey
Device Application Development MVP