Microsoft SQL Server 2008 R2 Specifications Page 36
- Page / 236
- Table of contents
- BOOKMARKS
Rated. / 5. Based on customer reviews
16 CHAPTER 1 SQL Server 2008 R2 Editions and Enhancements
Installation, Upgrade, and Migration Strategies
Like its predecessors, SQL Server 2008 R2 is available in both 32-bit and 64-bit editions, both
of which can be installed either with the SQL Server Installation Wizard or through a com-
mand prompt. As was briey mentioned earlier in this chapter, it is now also possible to use
Sysprep in conjunction with SQL Server for automated deployments with minimal administra-
tor intervention.
Last, DBAs also have the option to upgrade an existing installation of SQL Server or
conduct a side-by-side migration when installing SQL Server 2008 R2. The following sections
elaborate on the different strategies.
The In-Place Upgrade
An in-place upgrade is the upgrade of an existing SQL Server installation to SQL Server 2008
R2. When an in-place upgrade is conducted, the SQL Server 2008 R2 setup program replaces
the previous SQL Server binaries with the new SQL Server 2008 R2 binaries on the same
machine. SQL Server data is automatically converted from the previous version to SQL Server
2008 R2. This means that data does not have to be copied or migrated. In the example in
Figure 1-5, a DBA is conducting an in-place upgrade on a SQL Server 2005 instance running
on Server 1. When the upgrade is complete, Server 1 still exists, but the SQL Server 2005
instance, including all of its data, is now upgraded to SQL Server 2008 R2.
Upgrade
Pre-migration Post-migration
Server 1
SQL Server 2005
Server 1
SQL Server 2008 R2
FIGURE 1-5 An in-place upgrade from SQL Server 2005 to SQL Server 2008 R2
NOTE SQL Server 2000, SQL Server 2005, and SQL Server 2008 are all supported for an
in-place upgrade to SQL Server 2008 R2. Unfortunately, earlier editions, such as SQL Server
7.0 and SQL Server 6.5, cannot be upgraded to SQL Server 2008 R2.
- Database Administration 1 1
- —Ross MistRy 3
- —stacia MisneR 3
- Contents at a Glance 5
- Contents 7
- viii Contents 8
- Contents ix 9
- x Contents 10
- Contents xi 11
- xii Contents 12
- Contents xiii 13
- Acknowledgments 15
- xvi 16
- Introduction 17
- Pre-Release Software 18
- Support for This Book 19
- We Want to Hear from You 19
- Database 21
- Administration 21
- SQL Server 2008 R2 Editions 23
- Upload collection 27
- Premium Editions 32
- Core Editions 32
- Specialized Editions 33
- Hardware Requirements 34
- Software Requirements 35
- The In-Place Upgrade 36
- Side-by-Side Migration 38
- Multi-Server Administration 41
- REAL WORLD 43
- UCP Prerequisites 45
- Creating a UCP by Using SSMS 46
- UCP Post-Installation Steps 49
- Windows PowerShell 52
- Connecting to a UCP 53
- The Policy Tab 54
- The Security Tab 57
- The Data Warehouse Tab 59
- 1 year, or 2 years 60
- Data-Tier Applications 61
- Supported SQL Server Objects 64
- Visual Studio 2010 65
- Management Studio 69
- Data-Tier Application Wizard 72
- High Availability and 83
- Virtualization Enhancements 83
- Windows Server 2008 R2 86
- Server 2008 R2 86
- Guest Failover Clustering 87
- Real World 88
- /cc732035(WS.10).aspx 89
- Enabling CSV 96
- Click Next 101
- Consolidation and Monitoring 105
- SQLInstance01 106
- Monitoring 109
- Development 127
- Business Intelligence 127
- Scalable Data Warehousing 129
- Processing Architecture 130
- The Multi-Rack System 130
- The Data Rack 131
- The Control Rack 132
- The Control Node 132
- The Landing Zone Node 134
- The Backup Node 134
- The Management Node 134
- The Compute Node 134
- Hub-and-Spoke Architecture 135
- Shared Nothing Architecture 135
- Replicated Strategy 136
- Distributed Strategy 136
- DDL Extensions 137
- CREATE DATABASE 138
- CREATE TABLE 138
- Data Types 140
- Query Processing 141
- Data Load Processing 141
- Monitoring and Management 142
- Integration Services 143
- Reporting Services 143
- Master Data Services 145
- Master Data Manager 148
- Model Objects 149
- Product hierarchies 150
- Master Data Maintenance 151
- Business Rules 152
- Business rule validation 153
- Transaction Logging 154
- Importing Master Data 155
- Exporting Master Data 156
- Versions 157
- Security 158
- A user’s model permissions 159
- Programmability 162
- Matching Functions 163
- Complex Event Processing 165
- StreamInsight Highlights 166
- Data Structures 167
- The CEP Server 167
- Input Adapters 168
- Output Adapters 169
- Query Instances 169
- Deployment Models 169
- Hosted Assembly 169
- Standalone Server 169
- Event Types 170
- Adapters 171
- Query Templates 174
- The Event Stream Object 174
- The QueryTemplate Object 174
- Projection 175
- Filtering 175
- Event Windows 176
- FIGURE 8-3 Hopping windows 177
- Aggregations 179
- Grouping 180
- User-dened Functions 181
- Query Template Binding 182
- The Query Binder Object 182
- The Query Object 183
- Diagnostic Views 183
- Enhancements 185
- Aggregation 188
- Aggregation of an aggregation 189
- Page Numbering 190
- Read/Write Report Variable 190
- Layout Control 191
- Pagination Properties 192
- Data Synchronization 193
- Text Box Orientation 194
- Data Bars 195
- Sparklines 196
- Indicators 196
- Indicator types 197
- Reusability 198
- Shared Datasets 199
- Cache Refresh 199
- Report Parts 200
- Reusability CHAPTER 9 181 201
- Atom Data Feed 202
- Edit Sessions 203
- The Report Part Gallery 203
- Report Manager Improvements 204
- Report Viewer 205
- The report menu 205
- Report Viewer Improvements 206
- Improved Browser Support 206
- RDL Sandboxing 206
- RS Utility Scripting 207
- Self-Service Analysis with 209
- PowerPivot 209
- Modications to Excel 210
- Data Sources 211
- Linked Tables 213
- Copying and Pasting 213
- Data Preparation 213
- Relationships 214
- PowerPivot Reports 216
- PivotTables 216
- PowerPivot data 216
- Cube Functions 217
- The CUBEVALUE function 218
- Data Analysis Expressions 219
- Calculated Columns 219
- Measures 219
- DAX Functions 220
- Architecture 221
- The PowerPivot System Service 222
- The PowerPivot Database 223
- The PowerPivot Web Service 223
- Content Management 224
- The PowerPivot Gallery 224
- The Data Feed Library 225
- Data Refresh 225
- Linked Documents 225
- About the Authors 235
- What do 236
© 2020, manymanuals.com. All rights reserved. | 2.527 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals