In a previous post, I showed how to migrate a SQL CE 4 Beta database up to SQL Server (http://c1.ms/b9bzLx).  If you want to go the other way—from SQL Server down to CE—here’s how to do it: http://erikej.blogspot.com/2010/02/how-to-use-exportsqlce-to-migrate-from.html.