Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Differences Between SQL Server 2008 and SQL Server 2008 R2 from a developer's POV

I am setting up my development machine and I am wondering if I should install SQL Server 2008 R2 (for Developers) or SQL Server 2008 (for Developers) on my machine.

All of the databases that I work with are on SQL Server 2008 (not the R2). So I am torn. Should install what I am currently using? or should I be a bit forward looking and use the R2 version?

Will the client tools from the R2 install connect ok to the non R2 servers?

I guess in general what I want to know is what are the differences between R2 and non-R2 from a developer's point of view? (I don't really care about back end stuff too much.)

like image 942
Vaccano Avatar asked Aug 05 '10 21:08

Vaccano


1 Answers

As far as I'm concerned, in R2 more features previously available only in Enterprise edition are now available in Standard edition. Otherwise, no big difference.

like image 76
GSerg Avatar answered Oct 23 '22 16:10

GSerg