Call Savance Workplace Call Us: (248) 478-2555

Support Suite

User Login



 

Main

Knowledgebase
Manually Upgrade the Database
Posted by Tyler Skene on 04 December 2013 12:12 PM

When making any changes to the database, you will want to make a backup so that you do not have a chance of losing any data.

To make a backup of the database you have two options:

  1. Option 1 – Use SQL Management Studio
    1. https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-ver15#SSMSProcedure
  2. Option 2 – Using EIOBoard Admin
    1. Open up EIOBoard Server Admin
    2. Go to the SQL Tasks tab
    3. Edit the Backup Database job
    4. Confirm where it is being backed up to (@BackupLocation) and change it as needed
    5. Click Cancel or Save if you made changes to go back on the SQL Tasks tab
    6. Right click on the Backup Database job and say process now
    7. Look in the bottom left corner to follow the status of the job until it is complete
    8. Navigate to the location specified in the job and confirm the date/time of the file to make sure it is now

When making any changes to the database, you will want to make a backup so that you do not have a chance of losing any data.

To make a backup of the database you have two options:

  1. Option 1 – Use SQL Management Studio
    1. https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-ver15#SSMSProcedure
  2. Option 2 – Using EIOBoard Admin
    1. Open up EIOBoard Server Admin
    2. Go to the SQL Tasks tab
    3. Edit the Backup Database job
    4. Confirm where it is being backed up to (@BackupLocation) and change it as needed
    5. Click Cancel or Save if you made changes to go back on the SQL Tasks tab
    6. Right click on the Backup Database job and say process now
    7. Look in the bottom left corner to follow the status of the job until it is complete
    8. Navigate to the location specified in the job and confirm the date/time of the file to make sure it is now

 

Now that there is a backup of the database, the upgrade process can begin.

  1. Get the upgrade script from
    https://downloads.eioboard.com/Releases/10.5.7/EBCustomerDatabaseUpgrade1057.zip

    NOTE:
    You will have to change the 10.5.7 and 1057 to the correct version that you are upgrading to
  2. Open the file
  3. Select the database that you are upgrading
  4. Click Execute to run the script on the database

With the manual database upgrade, sometimes when multiple versions are skipped at once the prerequisites need to be put in, then the script needs to be ran a second time to get everything else in. If any error messages occur, run the database upgrade script again.

Finally your database should be upgraded. The SQL Server Management Studio can be used to check that the database was successfully upgraded.

  1. Open SQL Server Management Studio
  2. Expand the EIOBoard database (SQL Server > Databases > NameOfDatabase)

  3. Expand the Tables category
  4. Find and right click dbo.Versions
  5. Select Open Table

  6. The version can be viewed in the columns provided

If you have any further questions, call or message EIOBoard support.