SQL Server Compact Edition

For so many years I have been forced to work with Microsoft Access and application using it as a local and even shared network data storage, resulting in endless problems with corrupted and bloated database files.

I was very pleased when I found out that Microsoft had finally introduced a good (and free) replacement for the light weight Access databases called SQL Server Compact Edition.  As Access it is a file based database but with many of the features of  it’s big brother SQL Server.

Finally testing the new database I quite quickly got more and more dissapointed, not at the database engine but the tools.  When building on my first compact database using Visual Studio 2008 I almost immediately started getting errors like “The parameter is incorrect” and “The path is not of a legal form” for no particular reason. After googling for help I found out  that the only solution is to restart Visual Studio, every time! Also the useability leaves much to hope for  as now simple stuff like setting up relations and indexes requires switching between numerous dialogs.

Hoping the SQL Server Management Studio would provide better tools I found out the old 2005 version does not support the latest 3.5 CE database. After installing the new 2008 version, I was not surprised to see the same tools and dialogs as in Visual Studio. I guess a visual tool for defining the schema is out of the question.

I’m planning to use SQL Server Compact Edition in my next projects, hoping the engine will prove to compensate for the weak tools. You can be sure to read more about this subject in my later posts!

Advertisements

3 thoughts on “SQL Server Compact Edition

  1. Same problem here with no resolved solution. I use 3.5 in my projects, it works nice, but after a period of time (not precised) if you trie to acces table schema of database, error: “The path is not of a legal form” rises!

    Solution: The fastest way I found is to delete active data connection and reconnect the database!

    Seams to work for now.

  2. Visual Studio is a pain in the ass. The database server explorer is derived form SQL Server/SQL Server Compact 2008. So it lacks in default database features such as dumping the database and so on.

    To improve performance (Build performance) of VS (10 times better) you can disable the platform verfification task:

    1) Open the file %windir%\Microsoft.NET\Framework\v2.0.50727\Microsoft.CompactFramework.Common.Targets for editing.

    2) Go to the line which reads:

    Name=”PlatformVerificationTask”>

    and change it to:

    Name=”PlatformVerificationTask” Condition=”‘false'”>

    • I have the same problem. Although it’s a pain, closing the solution and reopening it seems to solve it.
      Unforetunately, I don’t have the file %windir%\Microsoft.NET\Framework\v2.0.50727\Microsoft.CompactFramework.Common.Targets on my computer. But then again, I only have SQLEXPRESS.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s