*.mdb to *.sdf RRS feed

  • Question


    Is there any way to convert *.mdb database to *.sdf ?
    Sunday, June 17, 2007 10:36 AM


All replies

  • Some 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.
    Sunday, June 17, 2007 3:14 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.




    Thursday, June 21, 2007 5:44 PM
  • Solution --> http://www.tiantekpro.com/mdb2sdf.aspx

    Monday, October 20, 2008 1:33 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?



    - Everett

    Wednesday, August 4, 2010 10:53 PM
  • No, 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 5, 2010 10:22 PM
    Thursday, August 5, 2010 9:08 AM