Upgrade Database

Overview

This option allows you to upgrade old version databases to the newer version e.g. existing 6.0.0.0 version databases are upgraded to the 6.0.1.0 version. This can be used in upgrading the company databases as well as the demo databases (if the user did not choose to re-install the demo databases when upgrading to the newer version of Interprise Suite).

Before upgrading the database, make sure to backup the company database before running the upgrade utility. Back up and Restore capabilities will be added to the Database Management Console in the future releases. For now, you can use Microsoft’s SQL Management Studio Express or Enterprise Manager for MS SQL Server 2008 (for SQL Server 2008 users) to backup your database.



Steps

To upgrade the database,

  1. Sign in to the machine where the databases were installed.

    The Database Management Console Utility only connects locally that is why it should be run on the machine where the databases are installed.

  2. The databases that need to be upgraded are marked as “Ready for upgrade”.

  3. Select the database to upgrade and click on the Upgrade Database ()button in the toolbar menu.
    Alternately, you can use the right click option and select Upgrade Database. Use default values if you want to start working with Connected Business right away.
  4. If you encounter errors while upgrading the database, the most possible cause of the error would be on the licensing issue. If your license has already expired, contact our sales team.
    Everytime you upgrade a database, you have to register the database by clicking on the Register Product (Register Product )button.
    Have your serial and confirmation number ready.
  5. A pop-up window will show advising you to create a backup for your database. Confirm that you have created a backup by ticking the checkbox "I have read and accepted the above." note and clicking Yes to proceed to with the upgrade.

  6. Once the upgrade starts, another pop-up window will appear showing the progress of the upgrade. A message prompt will appear after finishing the upgrade.


    The version number is then changed into the newer version of Connected Business.

  7. Sign in to the database from Connected Business to create the cache database. See also: Sign-In In to Connected Business.


For more information on configuring the connection to the databases, refer to Sign-In In to Connected Business.

 

 

 

 

  • Monday, 15 October 2012