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..
"Where is the justice of political power if it executes the murderer and jails the plunderer, and then itself marches upon neighboring lands, killing thousands and pillaging the very hills"
Khalil Gibran
Old Random Projects
    © Woody Hayday 2008-2024