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. 

UPDATE: I have posted this project as Open Source. You can download it here. You can also find it on CodeProject.com.

 I have been working on an application for a couple months with every intention of someday making the application available for purchase. But now, with my new blog underway I am contemplating releasing the application to my readers under an open source license. The two questions I have are;

Should I release this application/tool to the community under an open source license?

and

If I do release it under an open source license which license do I choose?

What application am I talking about?

I have created an application that can convert a SQL Server database to a SQL Mobile database. The application supports converting from SQL Server 7,  SQL Server 2000 and SQL Server 2005. You can convert the databases to either Microsoft SQL Server Compact 3.5 or Microsoft SQL Server Compact 3.1.  An option to copy the data as well as the schema is provided.

What does it look like?

The application uses a wizard to walk the user through the conversion process. Take a look at the screen shots below.

What do I need from you?

I would like comments and opinions on this topic? Anyone have experience releasing application open source?