Manually Upgrade the Database

Make a Backup

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

Upgrade Database with Script

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

1. Get the upgrade script from
   https://downloads.savanceworkplace.com/Releases/11.0.1/EBCustomerDatabaseUpgrade1101.zip
   NOTE: You will have to change the 11.0.1 and 1101 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.

Check Version in Database

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.