[RESOLVED] VS 2010 - sql server R2

[brin351]

Does VS 2010 intergrate better with sql server r2 like are there any benifits of using sql 2008 r2 over plain old sql server 2008. When I installed VS 2010 it installed packages for sql server 2008 R2 and I was wondering why R2. I dont have sql server 2008 R2 just 2005 and 2008 so I'm questioning if I it's worth getting R2.

Thanks

http://www.microsoft.com/sqlserver/2...2.aspx?pf=true

[gep13]

I would say that the inclusion of R2 in the release of VS 2010 is simply because that was the most recent version available, and Microsoft will always push the latest version of the software.

I am not familiar with all the differences in the versions though, so can't say whether it is worth it or not.

Gary

[brin351]

Thanks Gary,

I can't find anything that would induce me to move to R2. From what I've read it's more DBA and enterprise enhancements and intergration with win server R2 which are not my primary focus so I'm happy to stay with what I've got.

[gep13]

Sounds like a plan.

In theory, it "should" be a painless upgrade when the time comes.

Gary