Extract the upgrade files contained in
AffiliateWiz11UpgradeFrom6.zip
to a temporary location on your local computer. You will now see
several folders.

Version 11 includes changes to the Root
web.config Because this file also holds your custom database connection
string, you must first enter your database connection into the
web.config file before copying the updated files. If you don't your
database connection will break after the upgrade. Also, if you added
any custom tags to the web.config they should also be transferred. To do
so...

Open the web.config for your EXISTING installation of AffiliateWiz.
Find this line and copy the portion shown in GREEN:

Now, open the web.config found in the "AffiliateWiz11UpgradeFrom6\RootDirectory"
folder of the upgrade files. Replace the sample connection string with
your full connection string.<connectionStrings>
<add name="DBConnectionString" connectionString="Provider=sqloledb;Data
Source=IPADDRESSHERE;Initial Catalog=AffiliateWiz;User Id=usernamehere;Password=passwordhere"
/>
</connectionStrings>

Save the file.

From within SQL Query Analyzer,
execute the script called AffiliateWiz11UpgradeFrom6.sql on your existing
Affiliate Wiz database. This script is found in the /database/
folder in the location where you unzipped the files. The database is now converted to the new
format. If you are unsure how to do this, please review Steps
5-7 of the original database instructions found at:
support/SQLnewdb.asp
and noting that in step 5 the SQL script is named
AffiliateWiz11UpgradeFrom6.sql.

Note:
If any fatal errors occurred while running the database script, you
should record the error and email it to us. At the same time
restore the database to the backup copy you just made.
Do no proceed on with the installation.

These Warnings can be ignored:
Warning! The maximum key length is 900 bytes. The index 'ProductSpecificCommissions_Covered'
has...
Warning: The table 'tblaff_Affiliates' has been created but its
maximum row size (8280) exceeds...
Warning: The table 'tblaff_Affiliates' has been created but its
maximum row size (8680) exceeds...
Warning: The table 'tblaff_Affiliates' has been created but its
maximum row size (9080) exceeds...
Warning: The table 'tblaff_Affiliates' has been created but its
maximum row size (9380) exceeds...
Warning: The table 'tblaff_Affiliates_Data' has been created but
its maximum row size (10535) exceeds...

Note:
This script inserts a about 170,000 Geo-Location Records and may
take a number of minutes to complete. Be patient.

Copy the files AND FOLDERS from INSIDE
the directory called
"RootDirectory" to the web server directory where Affiliate
Wiz is installed. If you installed the software at
http://www.yourdomain.com/affiliatewiz
then that is where these files are to be copied. You will be
overwriting the existing files. Be sure to include the
subdirectories including Bin, Admin, Language, ChartImages,
EditorDialogs and Affiliate.