How to convert mdf files (sql2005) to sdf file (sqlce 3.1) Thanks a lot. -- Diego
You'd have to write code that queries the contents of the database mdf and writes to a new database sdf. Paul T. "Diego" wrote in message news:uuCBYD9yIHA.2068@TK2MSFTNGP05.phx.gbl... > How to convert mdf files (sql2005) to sdf file (sqlce 3.1) > > Thanks a lot. > > -- > Diego >
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 "Diego" wrote in message news:uuCBYD9yIHA.2068@TK2MSFTNGP05.phx.gbl... > How to convert mdf files (sql2005) to sdf file (sqlce 3.1) > > Thanks a lot. > > -- > Diego >
