14
SQL Server 2012 Upgrade Technical Guide
Chapter 17: Integration Services ..................................................................... 345
Introduction ................................................................................................................................ 345
Preparing to Upgrade to SSIS 2012.................................................................................. 346
SSIS Backward Compatibility ................................................................................................................... 346
64-Bit Considerations ................................................................................................................................. 347
SSIS Sample Package Overview ......................................................................................... 348
ETL Frameworks ............................................................................................................................................ 348
Master Package ............................................................................................................................................. 349
Execution Packages ..................................................................................................................................... 351
Running Upgrade Advisor .................................................................................................... 355
Installing SSIS 2012.................................................................................................................. 359
SSIS 2012 Server Overview ....................................................................................................................... 360
In-Place Upgrade.......................................................................................................................................... 361
Side-by-Side Upgrade ................................................................................................................................ 361
New Installations .......................................................................................................................................... 362
Project Conversion Wizard ................................................................................................... 363
Convert to Project Deployment Model ................................................................................................ 375
Additional References ............................................................................................................ 386
Chapter 18: Reporting Services ....................................................................... 387
Introduction ................................................................................................................................ 387
Reporting Services Editions ...................................................................................................................... 387
Upgrade Considerations ............................................................................................................................ 388
In-Place Upgrade vs. Side-by-Side Upgrade ..................................................................................... 391
Preparing to Upgrade ............................................................................................................. 392
Important Reporting Services Configuration Files .......................................................................... 393
Storing Configuration Settings ............................................................................................................... 393
Deprecated Features ................................................................................................................................... 393
Discontinued Functionality ....................................................................................................................... 394
Breaking Changes ........................................................................................................................................ 394
Behavior Changes ........................................................................................................................................ 395
15
SQL Server 2012 Upgrade Technical Guide
Updating Report Projects and Definitions for Use in BIDS .......................................................... 395
Upgrade Tools ............................................................................................................................................... 396
64-Bit Considerations ................................................................................................................................. 396
Known Issues and Workarounds ............................................................................................................ 396
Backup and Rollback Plan ......................................................................................................................... 397
Upgrading from SQL Server 2005 ..................................................................................... 398
In-Place Upgrade.......................................................................................................................................... 398
Side-by-Side Upgrade ................................................................................................................................ 404
Upgrading from SQL Server 2008 ..................................................................................... 408
In-Place Upgrade.......................................................................................................................................... 408
Side-by-Side Upgrade ................................................................................................................................ 409
Upgrading from SQL Server 2008 R2 .............................................................................. 409
In-Place Upgrade.......................................................................................................................................... 409
Side-by-Side Upgrade ................................................................................................................................ 410
Troubleshooting a Failed Upgrade ................................................................................... 410
Post-Upgrade Tasks ................................................................................................................ 412
Moving Reports Between SSRS 2005 and SSRS 2012 .................................................................... 414
Moving Reports Between SSRS 2008, SSRS 2008 R2, and SSRS 2012 ..................................... 414
Deploying Custom Extensions and Assemblies ................................................................................ 415
Verifying Configuration Files ................................................................................................................... 415
Uninstalling SSRS 2005, SSRS 2008, or SSRS 2008 R2 ................................................................... 415
Conclusion ................................................................................................................................... 416
Additional References ............................................................................................................ 416
Chapter 19: Data Mining................................................................................... 418
Introduction ................................................................................................................................ 418
Data Mining Features in SQL Server 2005, 2008, and 2008 R2 ............................ 419
Preparing to Upgrade ............................................................................................................. 422
Deprecated Features ................................................................................................................................... 422
Discontinued Functionality ....................................................................................................................... 423
Breaking Changes ........................................................................................................................................ 424