Sql server 2012 Upgrade Technical Guide Writers

12

 

SQL Server 2012 Upgrade Technical Guide 

 

 

 

Additional References ............................................................................................................ 301

 

Chapter 13: CLR .................................................................................................. 302

 

Introduction ................................................................................................................................ 302

 

Preparing to Upgrade ............................................................................................................. 302

 

Breaking Changes ........................................................................................................................................ 302 

Behavior Changes ........................................................................................................................................ 303 

Dynamic Management View (DMV) Changes ................................................................................... 308 

Visual Studio 2010 Compatibility ........................................................................................................... 308 

Additional References ............................................................................................................ 309

 

Chapter 14: SQL Server Management Objects ............................................... 310

 

Introduction ................................................................................................................................ 310

 

Preparing to Upgrade ............................................................................................................. 310

 

Deprecated Features ................................................................................................................................... 310 

Discontinued Functionality ....................................................................................................................... 311 

Upgrading from SQL Server 2005/2008/2008 R2 ...................................................... 311

 

SMO and PowerShell .............................................................................................................. 313

 

Conclusion ................................................................................................................................... 313

 

Additional References ............................................................................................................ 314

 

Chapter 15: Business Intelligence Tools ......................................................... 315

 

Introduction ................................................................................................................................ 315

 

BI Tools Users ............................................................................................................................. 315

 

Business Information Workers ................................................................................................................ 315 

Software Developers ................................................................................................................................... 316 

System Administrators ............................................................................................................................... 316 

BI Tools Overview ..................................................................................................................... 316

 

Import and Export Wizard ........................................................................................................................ 318 

SQL Server Data Tools ................................................................................................................................ 319 

SQL Server Management Studio ............................................................................................................ 321 

Analysis Services Deployment Wizard ................................................................................................. 322 

---

13

 

SQL Server 2012 Upgrade Technical Guide 

 

 

 

Reporting Services Configuration Manager ....................................................................................... 322 

Integration Services Deployment Wizard ........................................................................................... 323 

Integration Services Project Conversion Wizard .............................................................................. 323 

SQL Server Profiler ....................................................................................................................................... 324 

Report Builder ............................................................................................................................................... 324 

PowerPivot for Excel 2010 Add-In ......................................................................................................... 325 

Power View ..................................................................................................................................................... 327 

Data Mining Add-ins for Office 2007 ................................................................................................... 328 

PerformancePoint Dashboard Designer .............................................................................................. 328 

Preparing to Upgrade BIDS to SSDT Projects .............................................................. 328

 

Post Upgrade Tasks and Breaking Changes ................................................................. 331

 

Additional References ............................................................................................................ 332

 

Chapter 16: Analysis Services ........................................................................... 333

 

Introduction ................................................................................................................................ 333

 

Preparing to Upgrade: In-Place Upgrade vs. Side-by-Side Upgrade ................. 334

 

In-Place Upgrade.......................................................................................................................................... 334 

Side-by-Side Upgrade ................................................................................................................................ 335 

Preparing to Upgrade: Determining and Evaluating Potential Upgrade Issues

 .......................................................................................................................................................... 335

 

Deprecated Features ................................................................................................................................... 336 

Discontinued Functionality ....................................................................................................................... 337 

Breaking Changes ........................................................................................................................................ 337 

Behavior Changes ........................................................................................................................................ 338 

64-bit Considerations ................................................................................................................................. 339 

Upgrading from SSAS 2005, SSAS 2008, or SSAS 2008 R2 .................................... 339

 

Side-By-Side Upgrade ................................................................................................................................ 340 

In-Place Upgrade.......................................................................................................................................... 340 

Post-Upgrade Tasks ................................................................................................................ 342

 

Conclusion ................................................................................................................................... 343

 

Additional References ............................................................................................................ 344

 

---