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. 

I was rummaging through my library of source code I have written over the past 15 years and decided now is a good time to air some of it out. The first to be posted is a source code snippet repository. The purpose of this was to store all the little snips of code I had and be able to easily share these snips with some of my fellow coders. I realize that Visual Studio has wonderful code snip functionality but I wanted to be able to share a single repository of snips with my friends.

CodeCentral is three-tier application. A thick client windows forms application, a Web Service and a database. For the database there is a script in the \DBScripts folder. Just create a database and then execute this script against that database.

Download: CodeCentral.zip

Note: I did not create the syntax highlighting code. A friend of mine gave me this code but I believe he got it from codeproject. I searched but could not find the original article so if anyone comes across it please let me know so I can give credit where credit is due.

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?