Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to do a one-time migration of data from SQL Server Compact Edition to SQL Server 2008 Express Edition. I'm looking for a tool to do this kind of migration.

I've tried using Import and Export Data in SQL Server, but it doesn't let me import from SQL Server Compact Edition.

Anyone knows of a easy way to do it?

share|improve this question

SQL Compact is not the same as SQL Server, and stores its data in a different format. What you need to do is export the data from Compact and import it into SQL Server. Luckily, there is a tool on codeplex for this:

share|improve this answer

I believe you could do this with SSIS as well.

Really just a data flow from compact to SS.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.