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

Thank you for your feedback!


InstantKB 2.0.6 to 2011

This article details the steps necessary o upgrade from InstantKB.NET 2.0.6 to the latest InstantKB.NET 2011. If your eligible you can download the InstantKB.NET 2011 update from...

https://my.instantasp.co.uk/MyLicenses.aspx

You'll need to click the small "Download" link next to the InstantKB 2011 listing to begin the download. Once you've downloaded the ZIP file for this example please extract the contents of the ZIP file to your computers desktop. 

Before you begin the database upgrade please ensure you create a backup your InstantKB database.

The database upgrade script may take a couple of minutes to complete depending on the amount of data you have within your existing database. If a power or network failure occurs whilst running the upgrade script against the database it may not be possible to restore your data. For this reason we would strongly suggest creating a backup of your database before attempting to run our upgrade script.

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

The basic steps to upgrade are listed below...

1. Copy the InstantKB2011 folder to your c:\inetpub\wwwroot\ folder

2. Ensure the InstantKB2011 folder is marked as a web application within IIS

3. Make a backup of your existing InstantKB.NET 2.0.6 database

4. Open SQL Server Management Studio (SSMS) and connect to your InstantKB.NET 2.0.6 database. 

5. Within SSMS goto File > Open and navigate to c:\inetpub\wwwroot\InstantKB2011\DatabaseScripts\UpgradeScripts\.

Run the upgrade scripts listed below your restored  backup.

You will need to run all scripts in the following order...

  • 2.0.6_to_2011.sql

The script is located at located at c:\inetpub\wwwroot\InstantKB2011\DatabaseScripts\UpgradeScripts\

6. Update the freshly installed InstantKB 2011 "web.config" file within the 2011 install directory to point to your upgraded database. The default connection string is shown below...

<add key="InstantASP_ConnectionString" value="server=localhost;trusted_connection=true;database=InstantKB2011"/>
You may need to update this to something like...

<add key="InstantASP_ConnectionString" value="server=YOURSQLSERVERIP; uid=YOURSQLUSERNAME; pwd=YOURSQLPASSWORD; database=InstantKB2011"/>
7. Reapply any customizations you may have to the updated 2010 Classic Skin.

Upgrading from an older release?

If your upgrading from an earlier version of InstantKB you may need to run additioanl database scripts. For example if your currently running InstantKB.NET 2.0.1 you would need to run the following scripts in the order shown to fully upgrade your existing 2.0.1 database...

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

Important Consideration

Copy Existing Avatars & Profile Pictures

Copy your existing "Uploads" folder from your existing 2.0.6 installation folder into the root of your InstantKB.NET 2011 folder.

This will ensure profile pictures, images embedded within articles & avatars are still displayed correctly.

If you don't copy the uploads folder profiles images & images embedded within articles may not appear.

Web.Config Changes

The web.config file has changed quite substantially with 2011. For this reason we would suggest starting with the new InstantKB.NET 2011 web.config file.

That's It!

We hope you enjoy the 2011 update. Should you have any questions or feedback please open a support ticket or post your comments / questions within our community forums.