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