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.
It does some initial checks when the target Compact Edition assembly is selected and the version available did not seem to support Microsoft SQL Server Compact 3.5 Service Pack 1. I have modified the source to cater for SP1 and the updated version can be found here. I have tested it with the current application I am working on and there don't seem to be any issues, but further testing is probably required.
Comments