Web Wiz
  Knowledgebase Knowledgebase      Customer Login Customer Login


Web Wiz NewsPad SQL Server Upgrade


The following step by step guide describes how to upgrade the SQL Server version of Web Wiz NewsPad.
  1. IMPORTANT; Backup your existing SQL Server database. You may need to check with your web host as to what backup tools they give you. If you are using your own server make database backup using Microsoft SQL Server Management Studio.
     
  2. Use a zip utility program to extract the files to your hard drive keeping the original file structure intact.
    Extract files using a zip extraction tool
  3. Using an FTP Program remove from your web space all the old files and images for the existing NewsPad you want to upgrade, just keeping the uploads folder that contains content that your members have uploaded.

  4. Upload using your FTP Program the newspad directory containing all the files and images onto your web space making sure that the files stay in their original directories.
    Upload the files using FTP
  5. The newspad database folder located at newspad/database needs to have read, write, and modify permissions set on it, so that the installation wizard can write the database settings to the configuration files in this folder. Check with your web host that you have these permissions set, or if running the server yourself have a look at Setting Read, Write, and Modify Permissions.

  6. Type into your web browsers address bar the domain name and folder that you have uploaded the NewsPad to. The Web Wiz NewsPad installation/upgrade wizard will start automatically in your browser.
    Navigate to the location where you have uploaded Web Wiz NewsPad
  7. Select the type of upgrade that you require then click Next.
    Select Installation Type
  8. Select the database type that you are using, Microsoft SQL Server 2000 or above. Then click Next.
    Select the type of Database
  9. On the Database Connection Page, enter your information as follows;

    • Server - This will be the name or location of the SQL Server (URI, IP address, or localhost), you may also need to include the instance name (eg. localhost\SQLEXPRESS)
    • Database Name - This is the name of the actual database
    • Database Username - This will be the name of the user account you use to login into the SQL Server database
    • Database Password - This will be the password that you use with the SQL Server Username above

    Once you have filled in the fields, click Test Database Connection.
    Database Connection Details
  10. The Test Database Connection window will open, click Close Window
  11. Test Database Connection
  12. If the connection was not successful go back to stage 9 and complete the connection details again. If the database connection was successful click Next.

  13. The upgrade will now begin. This may take sometime to complete. Once it has completed you should see a message like the one below, click the NewsPad Homepage link to view your NewsPad.
    Web Wiz NewsPad Datbase Upgrade Complete
  14. Your NewsPad logins will remain the same including for any admin accounts.
     
  15. If you find that you are getting errors and pages not displaying please see Troubleshooting and Common Errors.
     


Become a Fan on Facebook Follow us on Twitter Find us on Google+ Community Forums Web Wiz Blogs Web Wiz News
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Unit B10, 9 Nimrod Way, East Dorset Trade Park, Wimborne, Dorset, BH21 7UH, United Kingdom.

Prices exclude VAT unless otherwise stated. VAT No. 988999105 - $, € prices shown as a guideline only.


Copyright ©2001-2016 Web Wiz Ltd. All rights reserved.