Local Install of Books Online 2012

The other day I needed to be able to study the SQL Server 2012 documentation, aka Books Online or BOL, to prepare for an exam while sitting on the train. So I was looking for the latest BOL download but that search wasn’t very successful. It took me a while to realize that what I was doing was no longer valid! Microsoft is no longer distributing the Books Online through the Downloads site!

Well, not entirely true, read on for details.

Because it took me some time to realize what was going on I decided to write a quick post on how to make the BOL 2012 available locally. Basically you’ve got two options.  Let’s start with the first one.

Method 1: Help Library Manager

The first – newly-introduced in SQL Server 2012 – method uses something called Help Library Manager.

This is a generic Microsoft product documentation management system, not exclusively for SQL Server.

Here are the steps to follow to get the SQL Server 2012 docs installed locally.  This method assumes that you’ve already got SQL Server 2012 installed and that your PC is connected to the internet.

To start, click the Manage Help Settings link located in the Documentation & Community subgroup of your SQL Server 2012 start menu shortcut group.

Manage Help Settings

This will open up the Help Library Manager mentioned earlier:

Help Library Manager: installing online content

Click the Install content from online link.  The Help Library Manager starts by fetching the list of available books.  Once finished, locate the SQL Server 2012 content:

Installing the SQL Server 2012 books

Click the Add link next to any book you’d like to install locally.  The link will change to Cancel as shown in following screenshot:

Selecting the books to be installed locally

When you’ve selected all books you’re interested in, click the Update button.  The Library Manager will now start downloading all the content you’ve requested.

Help Library Manager is downloading the requested packages

Now go and get a coffee.  When you’re back, you should be able to click the Finish button and the Books Online will be available locally:

SQL Server 2012 Books Online ready to be used

Method 2: Download from Download Center

It turns out Microsoft took into account that not all computers are able to access the internet, which is a requirement for method 1.  Microsoft does still have something available for download through the Download Center.  However, when I came across the link I hadn’t realized that this was actually the BOL download.  The reason that I didn’t realize this was because the stand-alone BOL download is now called Product Documentation for Microsoft SQL Server 2012 for firewall and proxy restricted environments. I thought this was documentation regarding firewall and other network-related issues but this is actually the full Books Online download!

So if you’re interested in the old-skool BOL download, check this out: [Download Center] Product Documentation for Microsoft SQL Server 2012 for firewall and proxy restricted environments

Have fun!

Valentino.

References
Add or Remove Product Documentation for SQL Server

Share

Tags: , ,

© 2008-2014 BI: Beer Intelligence? All Rights Reserved