*.mdb to *.sdf

Question

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

Answer 1

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.

Answer 2

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.

 

HTH,

Deepesh

Answer 3

Solution --> http://www.tiantekpro.com/mdb2sdf.aspx

Answer 4

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?

 

Thanks!

- Everett

Answer 5

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.