Import Access Data into SQL Server CE (.mdb to .sdf)

Question

I found several articles and discussions on how to import data from Access to SQL Server or SQL Server Express, but not to SQL Server CE. I can access both Access data and CE data in VS database browser with separate connections, but I don’t know how to move data from one to another. (I am using C #.) Any suggestions? Thanks.

Answer 1

You can watch PrimeWorks DataPort Wizard .

Answer 2

You can do this using SSIS or even in SQL Server Explorer if you do not want to do this programmatically.

Answer 3

you can also use the "sql server migration wizard" to convert it to a sql server database and use this tool to convert it back to a .sdf database