Sql server 2012 Upgrade Technical Guide Writers

8

 

SQL Server 2012 Upgrade Technical Guide 

 

 

 

Upgrading to SQL Server 2012 ........................................................................................... 207

 

In-Place Upgrade.......................................................................................................................................... 207 

Side-by-Side Upgrade ................................................................................................................................ 208 

Post-Upgrade Security Tasks ............................................................................................... 209

 

Post-Upgrade Security Testing ............................................................................................................... 209 

Conclusion ................................................................................................................................... 210

 

Additional References ............................................................................................................ 210

 

Chapter 6: Full-Text Search .............................................................................. 211

 

Introduction ................................................................................................................................ 211

 

Preparing to Upgrade ............................................................................................................. 211

 

Deprecated Features ................................................................................................................................... 212 

Breaking Changes ........................................................................................................................................ 212 

Behavior Changes ........................................................................................................................................ 212 

Running Upgrade Advisor ........................................................................................................................ 213 

Preparing for a Possible Rollback .......................................................................................................... 213 

Upgrading a Full-Text-Enabled Database ...................................................................... 214

 

In-Place Upgrade.......................................................................................................................................... 214 

Side-by-Side Upgrade ................................................................................................................................ 216 

Post-Upgrade Tasks ................................................................................................................ 219

 

Using Customized Noise-Word Files from a Previous SQL Server Version ............................ 219 

Conclusion ................................................................................................................................... 220

 

Additional References ............................................................................................................ 220

 

Chapter 7: Service Broker ................................................................................. 221

 

Introduction ................................................................................................................................ 221

 

Feature Changes ....................................................................................................................... 221

 

Preparing to Upgrade ............................................................................................................. 222

 

Disk Space Requirements.......................................................................................................................... 222 

Upgrade Tools ............................................................................................................................................... 223 

64-bit Considerations ................................................................................................................................. 224 

---

9

 

SQL Server 2012 Upgrade Technical Guide 

 

 

 

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

 

In-Place Upgrade.......................................................................................................................................... 224 

Side-by-Side Upgrade ................................................................................................................................ 225 

Post-Upgrade Tasks ................................................................................................................ 226

 

Restoring Settings ........................................................................................................................................ 226 

Routing Changes .......................................................................................................................................... 226 

Implementing Conversation Priorities .................................................................................................. 227 

Conclusion ................................................................................................................................... 227

 

Additional References ............................................................................................................ 228

 

Chapter 8: SQL Server Express ......................................................................... 229

 

Introduction ................................................................................................................................ 229

 

LocalDB ............................................................................................................................................................ 229 

Feature Changes ....................................................................................................................... 230

 

Preparing to Upgrade ............................................................................................................. 231

 

Deprecated Features ................................................................................................................................... 233 

Discontinued Functionality ....................................................................................................................... 233 

Breaking Changes ........................................................................................................................................ 233 

Behavior Changes ........................................................................................................................................ 233 

Upgrade Tools ............................................................................................................................................... 234 

64-Bit Considerations ................................................................................................................................. 235 

SQL Server 2012 Express Packages ....................................................................................................... 235 

System Requirements for SQL Server 2012 Express ....................................................................... 236 

Upgrading from SQL Server 2000 (MSDE) ..................................................................... 241

 

Upgrading to SQL Server 2012 Express .......................................................................... 241

 

In-Place Upgrade.......................................................................................................................................... 241 

Side-by-Side Upgrade ................................................................................................................................ 241 

Post-Upgrade Tasks ................................................................................................................ 243

 

Upgrading to LocalDB ............................................................................................................ 243

 

Upgrading to Other Editions of SQL Server 2012 ...................................................... 244

 

Upgrading to the SQL Server 2012 Web Edition ............................................................................. 245 

---