Sunday, June 17, 2007 10:36 AM
Sunday, June 17, 2007 3:14 PMModeratorSome of the tools from www.primeworks-mobile.com should be able to help you transfer your data. You could also code the conversion yourself in .NET, using the Jet OLEDB driver and the SQL CE client.
Thursday, June 21, 2007 5:44 PM
You can use Access Database Synchronizer (ADS) from Microsoft. http://www.microsoft.com/downloads/details.aspx?FamilyId=B967347A-5DD0-445C-8A9F-AEA3DB9EC4BC&displaylang=en
There are many things which you can do with this, for e.g. in addition to migrating data from a .mdb file to a .sdf file, you can also use ADS to keep them both in sync! You can also program against ADS using SqlCeRemoteDataAccess object of SQL Server 2005 Compact Edition. For details, please refer to the readme and the sample code which accompanies ADS.
Monday, October 20, 2008 1:33 PMSolution --> http://www.tiantekpro.com/mdb2sdf.aspx
Wednesday, August 04, 2010 10:53 PM
Sorry for resurrecting an old thread, but so far this ADS has been the closest thing to an official tool provided by Microsoft that I can find for migrating data from an Access mdb to a SQL Server Compact Edition sdf.
Unfortunately I noticed this statement in the Readme.doc:
3.6 Restrictions and Limitations of Using Access Database Synchronizer
You cannot synchronize data between an Access database on a desktop and a SQL Server Compact Edition database on the desktop.
Can anyone verify this tool should not/cannot be used to create an sdf database from the data contained in an mdb on a Windows desktop machine?
If so, does a Microsoft sanctioned tool exist for this type of conversion?
Thursday, August 05, 2010 9:08 AMModeratorNo, as far as I know, there is no Microsoft tool for this conversion. You must use one of the 3 solutions described above
Visit my SQL Compact blog - http://erikej.blogspot.com - Please mark as answer, if this was it.
- Proposed As Answer by EvBell Thursday, August 05, 2010 10:22 PM