Moved to:
Woody Hayday

Fresh Ideas

Hi there! This is my old blog, I don't hang around here much.
You can now find me trying to mix things up here:
Visit Subscribe To My Email List

From SQL Server 2008 r2 to SQL Compact Edition. Doing things the wrong way.

Program written using csharp and SQL Server 2008 r2? Great eh? … What about your users? …Doh. Anyway its good to re look at your data layer, so if this crops up and you need to switch to a more portable solution (Compact edition means anyone can use it on windows) then put in the time. Heres a few snippets of SQL changes that you will need to deal with in recreating your tables in SQL Compact Edition (moving from full blown SQL server auto scripting)

  • Dont try to SET anything, skip them. ANSI_NULLs, ANSI_PADDING
  • Replace CURRENT_TIMESTAMP with (getdate()) – easy to forget this but I always seem to use it as a default.
  • Keep constraints on line

Of course if you wrote your tables from scratch in T-SQL it probably wont be a problem.
This entry was posted in Snippets, SQL Server, Transactional SQL. Bookmark the permalink. Both comments and trackbacks are currently closed.
Woody Hayday

Comments Archive

Hi there. This is my old blog and it's archived, so you can no longer post new comments on this post (From SQL Server 2008 r2 to SQL Compact Edition. Doing things the wrong way.).

Read my new blog about writing software and stories at

The New Blog
A Quote..
"The way I am and the way I write are a unity. All my ideas and all my endeavours are myself. Thus, the autobiography is merely the dot on the i."
Old Random Projects
    © Woody Hayday 2008-2024