MDB to SDF???

[David Baldauff]

Does anyone know how to convert an Access database to a SQL Server for CE
....SDF? Otherwise if you know if there is a way to create the .SDF from XML
that would help too.

Thanks in advance!

 

[Ginny Caughey [MVP]]

David,

I don't know of such a conversion utility, but you can create the SDF file
programmatically on the device from an XML file using a DataSet. Use
DataSet.ReadXml to read the XMLfile, then write out the values to your SqlCe
database. If you want to get fancy, you could write a desktop Rapi app that
copied the XML file to the device, then invoked your device app to create
the SDF file so the device is loaded with the SDF file and ready for the
user after that point. If using XML files is too slow for you, you could
consider using other data formats such as CSV files. There is a CSV class on
www.opennetcf.org.

 

[Alex Feinman [MVP]]

There is a tool (haven't tried it myself)
http://www.efeyazilim.com/pocketsync