?
Solved

difference between sql 2008 and sql 2008 r2

Posted on 2011-04-23
8
Medium Priority
?
701 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 ???
0
Comment
Question by:chokka
  • 5
  • 2
8 Comments
 
LVL 22

Expert Comment

by:Om Prakash
ID: 35454967
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 35456330

R2 got new features:

What's New (SQL Server 2008 R2)
http://msdn.microsoft.com/en-us/library/bb500435.aspx
0
 
LVL 43

Accepted Solution

by:
Eugene Z earned 2000 total points
ID: 35456333
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

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

Where i can download the Patch file for upgrading ??
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 35456405
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 ...
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 35456413
one more
<Whether it will impact on SSIS Packages>
will not

R2 is 2008 with additional new features and components
0
 

Author Comment

by:chokka
ID: 35456748
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 !!
0
 
LVL 43

Assisted Solution

by:Eugene Z
Eugene Z earned 2000 total points
ID: 35456798
it is an another topic:
....it  can be ssis desgn related

--
however, you may consider sql 2008 SP2 to check\install
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question