• Verify that you are currently using Version 7. 
• Make a backup copy of the entire /banmanpro/ folder on your web server as well as the SQL database.  This upgrade will alter the database and a backup is required in the event of an error in the upgrade script.
• This upgrade alters a number of database indices.  If you have a large database this script may take a long time to run, in some cases minutes to an hour.  You may wish to disable ad serving under the Ban Man Pro tools option until the upgrade is completed.
• Verify that your web site or virtual directory is running .NET 2.0 and not 1.1.
  

Installation Instructions

1. Extract the upgrade files contained in banmanproSQL8upgrade.zip  to a temporary location on your local computer.  You will now see several folders including RootDirectory, Admin, Images, Advertiser, and Bin.
    
2. From within SQL Query Analyzer, execute the script called banmanproSQL8Upgrade.sql on your existing Ban Man Pro database.  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 banmanproSQL8Upgrade.sql.
   
   Note: If you receive the error below it is not fatal and can be ignored...BMP_proc_ObtainBannerForKeywordCampaignAdvanced4, Line 27
   Cannot use a CONTAINS or FREETEXT predicate on table 'Campaigns' because it is not full-text indexed.
    
3. Copy the files from the directory called "Root Directory" to the web server directory where Ban Man Pro is installed.  If you installed the software at http://www.yourdomain.com/banmanpro then that is where these files are to be copied.  You will be overwriting the existing files.  
    
4. Copy the files in the Images directory to the images directory.  This will most likely be... http://www.yourdomain.com/banmanpro/images.  
    
5. Copy the entire Admin and Advertiser folders into the folder where Ban Man Pro is installed. Be sure to include all subdirectories.
    
6. Copy the contents of the /bin/ folder to your Ban Man Pro /bin/ folder.  This will most likely be... http://www.yourdomain.com/banmanpro/bin/. 
    
7. Log into the Ban Man Pro admin console and verify everything is working properly.

If you plan on using the Geo-targeting feature, please click here for more information.
For information on the new demographic targeting feature, please click here.