Migrate from Windows 2008 SQL Server to SQL CE (for WebMatrix)
===

I have some stuff in my remote SQL Server 2008 DB. I want to put it inside my SDF database (the WebMatrix one). But I can't just copy the rows from Navicat (while viewing table for SQL Server 08) into the SDF database because some rows don't let you manually insert stuff.

So I need a way to "Migrate" from Windows SQL Server 2008 to SQL Server CE (.sdf).
<hr />

I think I have the right tools to accomplish this, but would appreciate it if someone can point me in the right direction.

I have:

 1. Visual Studio 2012 Ultimate RC
 2. Web Matrix
 3. Navicat Premium