*.mdf to *.sdf

Hi!
Is there any way to convert *.mdf database to *.sdf ?

Thank YouI've found special tool for that
It's called Data Port Wizard. It copies data from SQL Server / Access to / from SQL

CE 2.0 or SQL Mobile. You can get it here: www.primeworks.pt|||Hi Andrew is there any freeware to convert mdf to sdf. coz the primeworks trial period is only for 30 days.|||It would only take a couple of hours to write you own version

For each table in .mdf
Get .mdf schema
Write same schema in .sdf
For each table
read .mdf until eof
INSERT into .sdf

|||

hi Brian,

Thanks a lot for your help. I am a student in singapore, and i am now developing a soft ware in vb.net CE . Is it possible for you to give me a sample coding for this conversion if it is available with you.

Thank you