Optionally provide private feedback to help us improve this article...

Thank you for your feedback!


InstantKB 2016-1 to 2016-2

This article details the steps necessary o upgrade from InstantKB 2016-1 to the InstantKB 2016-2 release. For a complete list of changes between our InstantKB 2016-1 and 2016-2 releases please refer to our InstantKB 2016-2 Release Notes. InstantKB 2016-2 also introduces two breaking changes to consider if your upgrading an earlier version of InstantKB. 

Downloading InstantKB 2016-2

To begin your InstantKB 2016-2 download you'll need to visit your My.InstantASP account. Visit your "Licenses" page and click the "Download" button to the right of the InstantKB 2016-2 listing.

Once you've downloaded the ZIP file please extract the contents of the ZIP file to your local computer or web server desktop.

Upgrading Your InstantKB 2016-1 Database

IMPORTANT
Before you begin the database upgrade please ensure you create a backup your existing InstantKB 2016-1 database. Whilst it's highly unlikely you'll encounter any problems running our upgrade script it's always best practice to take a full back-up of your current InstantKB database before running our upgrade scripts.

We would also suggest performing any upgrade locally or within a testing / staging environment to familiarize yourself with the upgrade process. We would not suggest applying the upgrade directly into production without first testing the upgrade process locally.

The basic steps to upgrade are as follows...

1. Open SQL Server Management Studio (SSMS) and connect to your existing InstantKB 2016 database. Create a backup of your existing InstantKB 2016-1 database.

2. Restore your InstantKB 2016-1 database back-up under a new name, for example "InstantKB2016-2". We will run our upgrade script against this new restored database to add the new tables and stored procedures required for InstantKB 2016-2 whilst preserving all your existing data.

3. Again within SQL Server Management Studio go to File > Open and navigate to the DatabaseScripts folder within your InstantKB 2016-2 download. This is located at {InstantKB2016-2Install}\DatabaseScripts\UpgradeScripts\. You will need to open the "2016-1_to_2016-2.sql" file so we can execute this TSQL script against your restored InstantKB 2016-1 database..

4. Again within SQL Server Management Studio ensure your restored database is selected within the database drop down list within the SQL Server Management Studio toolbar. Once your sure you have your restored InstantKB2016-1 database selected (in this example the database name would be InstantKB 2016-2 as detailed in step 2 above) execute the 2016-1_to_2016-2.sql script against your restored InstantKB 2016-1 database. Once complete you will see the message "Query Executed Successfully" within the status bar of SQL Server Management Studio.

At this point your restored InstantKB 2016-1 database has been fully upgraded to InstantKB 2016-2. You can now point a fresh installation of the InstantKB 2016-2 files to this upgraded database. You'll notice all your existing data is preserved and you can login using the same credentials as before.

Install the InstantKB 2016-2 Files

NOTE
If you've not modified InstantKB 2016-1 you can simply copy the InstantKB 2016-2 files over the top of your existing InstantKB 2016-1 files. You may wish to exclude the web.config file from InstantKB 2016-2 and keep your InstantKB 2016-1 web.config as this has not changed between InstantKB 2016-1 and InstantKB 2016-2. 

1. Copy the InstantKB2016 folder within the InstantKB 2016-2 download to your c:\inetpub\wwwroot\ folder or alongside your existing InstantKB 2016-1 folder within your staging or production environment. You can rename the InstantKB2016 folder to anything you wish. For example Support or KB.

2. Ensure the folder containing your InstantKB 2016-2 web site files created above is marked as a web application within IIS similar to your existing InstantKB 2016-1 installation. If your installing InstantKB 2016-2 into a new web site within IIS the web site is already an application You should ensure InstantKB 2016-2 is running under a .NET 4.0 integrated application pool. We would suggest using the same application pool as your existing InstantKB 2016-1 installation.

If your opening the application via Visual Studio configuring IIS is not necessary for local development but will be required for deployment into a staging or production environment. InstantKB uses IIS Express built into Visual Studio for local development. 

3. Navigate to your older InstantKB 2016-1 installation folder within Windows Explorer. and copy the web.config file into your clip board. Paste your existring InstantKB 2016-1 web.config over the top of the web.config provided with InstantKB 2016-2. The web.config file has not changed between these releases so it's perfectly safe to copy your InstantKB 2016-1 web.config into your InstantKB 2016-2 installation.

4. Copy your the "Uploads" from within the root of your existing InstantKB 2016-1 installation into the root of your new InstantKB 2016-2 folder. Overwrite the Uploads folder within InstantKB 2016-2 with your existing InstantKB 2016-1 Uploads folder.

5. Reapply any visual changes you may have made to your previous InstantKB 2016 Classic skin to the newer InstantKB 2016-1 Classic skin. 

Updated Files & Folders

If you've customized your InstantKB 2016-1 installation you may wish to only copy the updated files within InstantKB 2016-2. To help we've provided a complete list of all folders and files you'll need to copy into your existing InstantKB 2016-1 installation to avoid a completely new installation. 

Folders

The following folders within the root of your InstantKB web site installation have been updated with InstantKB 2016-2. 

  • Admin
  • Bin
  • Dialogs
  • Globalization
  • js
  • Staff

Updated Skin Files

The following folders and files within Skins/Classic has been modified or updated with InstantKB 2016-2...

  • Admin 
  • Controls/ViewTicket.ascx
  • Controls/ViewSearchOptions.ascx
  • Dialogs
  • Staff
  • Styles/1-debug-common.css
  • Styles/2-debug-kb.css
  • Documentation.Master
  • MasterPage.Master

Upgrading from an older release?

If your upgrading from an earlier version of InstantKB you may need to run additional database scripts. For example if your currently running InstantKB 2.0.1 you would need to run the following scripts in the order shown to fully upgrade your existing 2.0.1 database to the latest 2016 schema whilst keeping all your existing data...

  • 2.0.1_to_2.0.2.sql
  • 2.0.2_to_2.0.3.sql
  • 2.0.3_to_2.0.4.sql
  • 2.0.4_to_2.0.5.sql
  • 2.0.5_to_2.0.6.sql
  • 2.0.6_to_2011.sql
  • 2011_to_2011_1.sql
  • 2011-1_to_2011_2.sql
  • 2011-2_to_2014.sql
  • 2014_to_2014-1.sql
  • 2014-1_to_2015.sql
  • 2015_to_2015-1.sql
  • 2015-1_to_2015-2.sql
  • 2015-2_to_2016.sql
  • 2016_to_2016-1.sql
  • 2016-1_to_2016-2.sql

You should always install the same version of the InstantKB files to march your InstantKB database version.

Copy Existing Uploads Folder

Don't forget to copy your existing "Uploads" folder from your existing InstantKB 2016 installation folder into the root of your InstantKB 2016-1 folder. You will be prompted to overwrite the empty "Uploads" folder provided within the InstantKB 2016 installation. When prompted overwrite the empty InstantKB 2016 Uploads folder with your existing InstantKB 2015 Uploads folder. This will ensure uploads, profile pictures & images embedded within articles are still displayed correctly. If you don't copy the uploads folder profiles images & images embedded within articles may not appear after the upgrade.

Web.Config Changes

The web.config has not changed between InstantKB 2016-1 and InstantKB 2016-2. 

That's It!

We hope you enjoy the 2016-1 update. Should you have any questions or feedback please open a support ticket, contact us or post your questions within our community forums.