Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover Page
Title Page
Copyright Page
Contents
Introduction
Chapter 1: Upgrade Planning and Deployment
Introduction
Feature Changes in SQL Server 2012
Upgrading SQL Server 2008 to SQL Server 2008 R2
Preparing to Upgrade
Upgrade Strategies
Upgrade Tools
SQL Server 2012 Setup
Allowable Upgrade Paths
Application and Connection Requirements
Upgrading Applications that Use the .NET Framework
Plan for Backups
Upgrading Both Windows and SQL Server
Upgrading Multiple Instances
Upgrading Very Large Databases
Upgrading High Availability Servers
Minimizing Upgrade Downtime
Developing an Upgrade Plan
Treat the Upgrade as an IT Project
Minimize Variables Involved in the Upgrade
Create Upgrade Checklists
Test the Upgrade Plan
Develop Acceptance Criteria and Rollback Steps
Post-Upgrade Tasks
Integrate the New Instance into Its New Environment
Determine Application Acceptance
Run the SQL Server 2012 Best Practices Analyzer
Troubleshooting an Upgrade
Decommission and Uninstall After a Side-by-Side or New Hardware Upgrade
Considerations for Upgrading without a DBA
Conclusion
Additional References
Chapter 2: Management Tools
Introduction
Feature Changes in SQL Server 2012 Management Tools
Changes in SSMS
Database Engine Tuning Advisor
Changes in SQL Server Configuration Manager
Changes in SQL Server Profiler
Preparing to Upgrade
Deprecated Features
Discontinued Functionality
Breaking Changes
Behavior Changes
Upgrade Tools
64-Bit Considerations
Known Issues and Workarounds
SQL Server Agent
In-Place and Side-By-Side Upgrade
Upgrading from SQL Server 2005
Upgrading from SQL Server 2008/2008 R2
Project Files
Post-Upgrade Tasks
Database Maintenance Plans
Database Diagrams
Conclusion
Additional References
Chapter 3: Relational Databases
Introduction
Relational Database Configurations
Upgrade Considerations
Full-Text Search
What Can Be Upgraded?
What Cannot Be Upgraded?
In-Place Upgrade vs. Side-by-Side Upgrade
In-Place Upgrade
Side-by-Side Upgrade
Evaluating Potential Upgrade Issues
Deprecated Features
Discontinued Functionality
Breaking Changes
Behavior Changes
Preparing for an Upgrade
Preparing for an In-Place Upgrade
Preparing for a Side-by-Side Upgrade
Performing an Upgrade
Performing an In-Place Upgrade
Performing a Side-By-Side Upgrade
Post-Upgrade Tasks
In-Place Upgrade
Side-by-Side Upgrade
General Post-Upgrade Tasks
Use Plan Hints
Important Information About Query Plans
Connecting Client Applications to SQL Server 2012
Conclusion
Additional References
Chapter 4: High Availability
Introduction
Preparing to Upgrade
In-Place Upgrade
Side-by-Side Upgrade on the Same Standalone Server or Cluster
Side-by-Side Upgrade to a Separate Standalone Server or Cluster
Decommissioning and Disabling the Original Instance or Database in a Side-by-Side Upgrade
Methods for Side-by-Side Upgrades to a Separate Server or Cluster
Which SQL Server Upgrade Method Should You Use?
Minimizing Downtime During the Upgrade
Prepare for SQL Server 2012
Devise an Upgrade Plan
Test the Upgrade Plan
Prepare Servers and Instances for SQL Server 2012
Upgrading Failover Cluster Instances
Feature Changes in SQL Server 2012 Failover Clustering
Operating System Versions and SQL Server 2012 Failover Clustering
Considerations for Upgrading a SQL Server 2005 Failover Cluster to SQL Server 2012
Considerations for Upgrading SQL Server 2008 or SQL Server 2008 R2 to SQL Server 2012
Considerations for Upgrading a Pre-Release Version of SQL Server 2012 to RTM
Upgrading a Failover Clustering Instance to SQL Server 2012
Additional References for Clustering Upgrades
Upgrading Mirrored Databases
Feature Changes in SQL Server 2008 R2 Database Mirroring
In-Place Upgrade
Side-by-Side Upgrade to a New Server
Additional References for Upgrading with Mirrored Databases
Upgrading Log Shipped Databases
Feature Changes in SQL Server 2012 Log Shipping
Log Shipping Upgrade Scenarios
Upgrading with Multiple Secondaries
Steps to Upgrade Log Shipping without a Role Change
Steps to Upgrade Log Shipping with a Role Change
Steps to Upgrade Side-by-Side to a New Server or Cluster
Additional References for Upgrading Log Shipping
Upgrading Replicated Databases
Feature Changes in SQL Server 2012 Replication
Planning an Upgrade with Replication
In-Place Upgrade
Side-by-Side Upgrade to a New Server or Cluster
Additional Information for Upgrading Replicated Databases
Conclusion
Additional References
Chapter 5: Database Security
Introduction
New Security Features
New Configuration Tools
Configuring Services and Connections
Service Account Security
Configuring Features
SQL Server Audit
Preparing to Upgrade
Deprecated Features
Discontinued Features
Breaking Changes
Behavior Changes
Pre-Upgrade Security Tasks
Upgrading to SQL Server 2012
In-Place Upgrade
Side-by-Side Upgrade
Post-Upgrade Security Tasks
Post-Upgrade Security Testing
Conclusion
Additional References
Chapter 6: Full-Text Search
Introduction
Preparing to Upgrade
Deprecated Features
Breaking Changes
Behavior Changes
Running Upgrade Advisor
Preparing for a Possible Rollback
Upgrading a Full-Text-Enabled Database
In-Place Upgrade
Side-by-Side Upgrade
Post-Upgrade Tasks
Using Customized Noise-Word Files from a Previous SQL Server Version
Conclusion
Additional References
Chapter 7: Service Broker
Introduction
Feature Changes
Preparing to Upgrade
Disk Space Requirements
Upgrade Tools
64-bit Considerations
Upgrading from SQL Server 2005/2008/2008 R2
In-Place Upgrade
Side-by-Side Upgrade
Post-Upgrade Tasks
Restoring Settings
Routing Changes
Implementing Conversation Priorities
Conclusion
Additional References
Chapter 8: SQL Server Express
Introduction
LocalDB
Feature Changes
Preparing to Upgrade
Deprecated Features
Discontinued Functionality
Breaking Changes
Behavior Changes
Upgrade Tools
64-Bit Considerations
SQL Server 2012 Express Packages
System Requirements for SQL Server 2012 Express
Upgrading from SQL Server 2000 (MSDE)
Upgrading to SQL Server 2012 Express
In-Place Upgrade
Side-by-Side Upgrade
Post-Upgrade Tasks
Upgrading to LocalDB
Upgrading to Other Editions of SQL Server 2012
Upgrading to the SQL Server 2012 Web Edition
Upgrading to SQL Server 2012 Standard Edition
Conclusion
Additional References
Chapter 9: SQL Server Data Tools
Introduction
Preparing to Upgrade
Upgrading Visual Studio 2010 Database Projects to SSDT
Breaking and Behavior Changes
SQL Server Database Project Template
Schema Definition Files
Schema Comparison Files
SQLCMD Variable Definitions
Server Logins
Other Breaking and Behavior Changes
Pre-Upgrade Tasks
Convert .dbschema Files to .dacpac Files
Convert SQLCMD Variable Definitions
Post-Upgrade tasks
Change the Debugging Instance for Full-Text Search
Correct Linked Server Definitions That Use SQLCMD Variables
Additional References
Chapter 10: Transact-SQL Queries
Introduction
Preparing to Upgrade
Backup and Rollback Plan
Deprecated Features
Discontinued Features
Breaking Changes
Behavior Changes
Upgrade Tools
64-Bit Considerations
Known Issues and Workarounds
Upgrading from SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2
In-Place Upgrade
Side-by-Side Upgrade
Post-Upgrade Tasks
Conclusion
Additional References
Chapter 11: Spatial Data
Introduction
Preparing to Upgrade
Deprecated Features
Discontinued Functionality
Breaking Changes
Behavior Changes
Post-Upgrade Tasks
Conclusion
Additional References
Chapter 12: XML and XQuery
Introduction
Preparing to Upgrade
Deprecated Features
Discontinued Functionality
Breaking Changes
Behavior Changes
Post-Upgrade Tasks
Features Added in SQL Server 2012
Features Added in SQL Server 2008
Conclusion
Additional References
Chapter 13: CLR
Introduction
Preparing to Upgrade
Breaking Changes
Behavior Changes
Dynamic Management View (DMV) Changes
Visual Studio 2010 Compatibility
Additional References
Chapter 14: SQL Server Management Objects
Introduction
Preparing to Upgrade
Deprecated Features
Discontinued Functionality
Upgrading from SQL Server 2005/2008/2008 R2
SMO and PowerShell
Conclusion
Additional References
Chapter 15: Business Intelligence Tools
Introduction
BI Tools Users
Business Information Workers
Software Developers
System Administrators
BI Tools Overview
Import and Export Wizard
SQL Server Data Tools
SQL Server Management Studio
Analysis Services Deployment Wizard
Reporting Services Configuration Manager
Integration Services Deployment Wizard
Integration Services Project Conversion Wizard
SQL Server Profiler
Report Builder
PowerPivot for Excel 2010 Add-In
Power View
Data Mining Add-ins for Office 2007
PerformancePoint Dashboard Designer
Preparing to Upgrade BIDS to SSDT Projects
Post Upgrade Tasks and Breaking Changes
Additional References
Chapter 16: Analysis Services
Introduction
Preparing to Upgrade: In-Place Upgrade vs. Side-by-Side Upgrade
In-Place Upgrade
Side-by-Side Upgrade
Preparing to Upgrade: Determining and Evaluating Potential Upgrade Issues
Deprecated Features
Discontinued Functionality
Breaking Changes
Behavior Changes
64-bit Considerations
Upgrading from SSAS 2005, SSAS 2008, or SSAS 2008 R2
Side-By-Side Upgrade
In-Place Upgrade
Post-Upgrade Tasks
Conclusion
Additional References
Chapter 17: Integration Services
Introduction
Preparing to Upgrade to SSIS 2012
SSIS Backward Compatibility
64-Bit Considerations
SSIS Sample Package Overview
ETL Frameworks
Master Package
Execution Packages
Running Upgrade Advisor
Installing SSIS 2012
SSIS 2012 Server Overview
In-Place Upgrade
Side-by-Side Upgrade
New Installations
Project Conversion Wizard
Convert to Project Deployment Model
Additional References
Chapter 18: Reporting Services
Introduction
Reporting Services Editions
Upgrade Considerations
In-Place Upgrade vs. Side-by-Side Upgrade
Preparing to Upgrade
Important Reporting Services Configuration Files
Storing Configuration Settings
Deprecated Features
Discontinued Functionality
Breaking Changes
Behavior Changes
Updating Report Projects and Definitions for Use in BIDS
Upgrade Tools
64-Bit Considerations
Known Issues and Workarounds
Backup and Rollback Plan
Upgrading from SQL Server 2005
In-Place Upgrade
Side-by-Side Upgrade
Upgrading from SQL Server 2008
In-Place Upgrade
Side-by-Side Upgrade
Upgrading from SQL Server 2008 R2
In-Place Upgrade
Side-by-Side Upgrade
Troubleshooting a Failed Upgrade
Post-Upgrade Tasks
Moving Reports Between SSRS 2005 and SSRS 2012
Moving Reports Between SSRS 2008, SSRS 2008 R2, and SSRS 2012
Deploying Custom Extensions and Assemblies
Verifying Configuration Files
Uninstalling SSRS 2005, SSRS 2008, or SSRS 2008 R2
Conclusion
Additional References
Chapter 19: Data Mining
Introduction
Data Mining Features in SQL Server 2005, 2008, and 2008 R2
Preparing to Upgrade
Deprecated Features
Discontinued Functionality
Breaking Changes
Behavior Changes
Running Upgrade Advisor
Upgrading from SQL Server 2005
In-Place Upgrade
Side-by-Side Upgrade
Post-Upgrade Tasks
Upgrading from SQL Server 2008 and 2008 R2
Conclusion
Additional References
Chapter 20: Other Microsoft Applications and Platforms
Introduction
Microsoft Lync Server 2010
Microsoft Office SharePoint Server 2010
Microsoft System Center
Microsoft Dynamics
Conclusion
Additional References
Appendix 1: Version and Edition Upgrade Paths
Appendix 2: SQL Server 2012: Upgrade Planning Checklist
Appendix 3: Code and Table Images
← Prev
Back
Next →
← Prev
Back
Next →