How to update a running BEXIS2 instance to version 2.12.1

Goal

It is recommended to update a running BEXIS2 instance into the version 2.12.1.

---

Introduction

This is a task of a system manager.

---

Workflow

Upgrade the current database

1. Be sure that you have a backup of your database. It helps you to return changes in case any failure.
2. Find the version of the database. It would be the same as the version of your BEXIS2 instance.
3. Find the compatible database update script from the downloaded BEXIS2.12.1 package inside the folder BEXIS2121_full\BEXIS2121\Database update scripts.
4. Run the script on the database to upgrade it to the version 2.12.1. Note: From BEXIS2.11.3 to the version 2.12.1 you need to run the first Update_Script_2113to212 and then the Update_Script_212to2121.
5. If the query was successfully executed, run also the last line COMMIT.

Upgrade the website

1. Copy and replace the inside of the BEXIS2121_full\BEXIS2121\Site folder into the Site folder of the running version. Note: You may avoid copying the Web.config or do the changes inside this file manually.
2. Compare the workspace of currently running instance with contents of BEXIS2121_full\BEXIS2121\Workspace. Copy and paste differences.

Update seed data generation

1. Open ~\Workspace\Modules\Modules.Catalog.
2. Change the value of status for all modules to pending.
3. Restart the website.
4. Change the value of status for all modules to active.

---

###Test

Test Database Test of upgrading the database in this point is required. Check if the column token exists in the public table user.

Test Website Restart the website from IIS and run it.

Test update seed data generation After restarting the website when the modules are in pending, statuses should be changed to inactive.

Test Update website Run the new version and log in normally.