I have been using the great SQL Server to SQL Server Compact Edition Database Copy utility written by Scott "Johnny" Smith. It really is incredibly useful so that one can design/manage your database on a non-compact SQL Server instance and then copy both the schema and data over into a .SDF file for use with Compact Edition.