Database Reference
In-Depth Information
This chapter begins with SQL Server 2008 R2 version's new features and enhancements, and
adding the service pack features using Slipstream technology. Then an explanation towards
how best the master data services can help in designing and adopting key solutions, working
with data-tier applications to integrate development into deployment, and an explanation of
how best the federated servers enhancement can help to design highly scalable applications
for data platforms.
Adding SQL Server 2008 R2 Service Pack
features using Slipstream technology
The success of any project relies upon the simpler methods of implementation and a process
to reduce the complexity in testing to ensure a successful outcome. This can be applied
directly to the process of SQL Server 2008 R2 installation that involves some downtime, such
as the reboot of servers. This is where the Slipstream process allows other changes to the
databases or database server. This method offers the extension of flexibility to upgrade the
process as an easier part, if there are minimal changes to only those required for the upgrade
process. The following recipe is prepared to enable you to get to know Slipstream.
Slipstream is the process of combining all the latest patch packages into the initial
installation. The major advantage of this process is time, and the capability to include all the
setup files along with service pack and hotfixes. The single-click deployment of Slipstream
helps us to merge the original source media with updates in memory and then install the
update files to enable multiple deployments of SQL Server 2008 R2.
Getting Ready
In order to begin adding features of SQL Server using Slipstream, you need to ensure you have
the following in place:
F .NET Framework 3.5 Service Pack 1: It helps improvements in the area of data
platform, such as ADO.NET Entity Framework, ADO.NET data services, and support for
new features of SQL Server 2008 version onwards.
You can download .NET Framework 3.5 Service Pack 1 from http://www.
microsoft.com/downloads/en/details.aspx?FamilyID=ab99342f-5d1a-
413d-8319-81da479ab0d7&displayla ng=en .
F Windows Installer 4.5: It helps the application installation and configuration service
for Windows, which works as an embedded chainer to add packages to a multiple
package transaction. The major advantage of this feature enables an update to
add or change custom action, so that the custom action is called when an update
is uninstalled.
 
Search WWH ::




Custom Search