We help IT Professionals succeed at work.

difference between sql 2008 and sql 2008 r2

chokka
chokka asked
on
Medium Priority
717 Views
Last Modified: 2012-06-21
What is the difference SQL 2008 SP 1 and SQL 2008 R2 Edition? Whether it will impact on SSIS Packages ? Which works on one edition to another ???
Comment
Watch Question

Top Expert 2010

Commented:
EugeneZ ZhitomirskySQL SERVER EXPERT
CERTIFIED EXPERT

Commented:

R2 got new features:

What's New (SQL Server 2008 R2)
http://msdn.microsoft.com/en-us/library/bb500435.aspx
SQL SERVER EXPERT
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
chokkaStudent

Author

Commented:
Can i upgrade from SQL 2008 SP 1 to R2 Edition .. by running Patch file ??

Where i can download the Patch file for upgrading ??
EugeneZ ZhitomirskySQL SERVER EXPERT
CERTIFIED EXPERT

Commented:
you  can not
upgrade..sql 2008 to 2008R2-- by running sql2008 patch..


see sql server 2008R2 as another sql server version
it was planned as sql server 2010
--
you need to buy sql2008R2 ...
EugeneZ ZhitomirskySQL SERVER EXPERT
CERTIFIED EXPERT

Commented:
one more
<Whether it will impact on SSIS Packages>
will not

R2 is 2008 with additional new features and components
chokkaStudent

Author

Commented:
Eugenez :-

If you look at most recent questions posted on EE, will carry an issue " Dynamically passing connection string to SSIS Package "

I have wrote Source Code for calling SSIS Package and passing values ..! Which has no syntax error - Infact, Package results Succeed !!! But internally package is not doing the Transaction.

When i checked with one another coder from different location, he mentioned it could be SQL 2008 SP1, Here in SQL 2008 R2 it works !!
EugeneZ ZhitomirskySQL SERVER EXPERT
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.