I have updated the SQL Server to Sql Server Compact Edition Database copy utility. A few users found a couple issues. Here is what was fixed or added.

-- Added the ability to select the schema you wish to copy. For most databases this will simply be "dbo".
-- Fixed a bug where the application did not recognize a valid version of "System.Data.SqlServerCe.dll".
-- Fixed an issue which limited the database size to 256Mb. The limit is now set to 4091Mb, the maximum size supported by SQL Compact Edition.
-- Fixed an issue where the application assumed a single column primary key. (courtesy of Ricardo Lopes)
-- Fixed an issue introduced in the lastround of fixes involving the ability to select the schema to use from SQL Server 2005. No schemas are available for a SQL 2000 database.  (courtesy of Ricardo Lopes)

 I have posted the new source code as well as the executable here.

After receiving some good email recommendations on my post, To Open Source or Not to Open Source? That is the question!, I have decided to open source the application to my readers.

You can find the download details here.

Feel free to email me with questions or comments.