copying data from a SQL server-table to a SQLCE-table
After reading the comment, I would like to suggest that you can use SQL Server Compact bulk copy library


Check sqlcebulkcopy.codeplex.com
Or you can use ErikEJ’s blog post to migrate and the utility SQLCMD.
Or create Integration Services packages that write data to SQL Server Compact databases check link