SQL 2005 vs SQL 2008

Developer
Oct 28, 2008 at 10:48 AM
Is there a strong reason to prefer one over the other?
2008 has a built-in DateTimeOffset data type, but that's not a compelling reason to break SQL 2005 compatibility.

I ask because I am setting up a new development PC, and I'll probably install SQL 2008, just because it's the current version.
Despite that, I can till test on a SQL 2005 database on another PC if SQL 2005 compatibility is desired.

Coordinator
Oct 31, 2008 at 9:37 PM
For mass appeal we'd likely want to target 2005.  However, I'm sure if we target 2008, it wouldn't be a big deal to tweak things to work in 2005.  Let's try to target 2005, but if you can save time by developing for 2008 then by all means go for it.
Developer
Nov 3, 2008 at 7:24 PM
Ok, I'm installing SQL 2008 on the new PC. But I will stick to SQL 2005 features.