TABLE OF CONTENTS

Overview 

In black and white, VIDIZMO consist a web application  and databases. To upgrade the solution, both application and databases would need to be upgraded to latest version.


Step-1: Database Upgrade 

Deploy an upgrade on VIDIZMO databases. The process of database upgrade is done by running upgrade scripts on your VIDIZMO databases.


Database Upgrade Scripts

The upgrade scripts are based on PowerShell, and they are executed in the following order:  

  • VidizmoDBScripts.zip
  • NotificationDBScripts.zip
  • DeploymentScripts.zip
Note: VIDIZMO support team will provide database upgrade scripts. 


Note: The database upgrade scripts are provided to you in form of compressed (zipped) files.

C:\Users\james.corden\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\22BFD744.tmp

Note: In this example, we extract all upgrade scripts in “C:\Scripts\” and create folder structure like file names mentioned above. 


Note: Make sure to Unblock the downloaded zip file before you extract it. Right click the downloaded zip file, click properties from drop down menu to open properties, and check the box that says “Unblock”. Click Apply and Ok to confirm changes and close the properties dialog box.


Note: For upgrading VIDIZMO application and notification databases, you would need to execute the process using upgrade scripts for both application and notification databases.


Note: You would need a SQL Server user account for use with upgrade scripts. The SQL user account that you specify below in upgrade process must have DB_OWNER permissions on VIDIZMO databases for successful upgrade.
Note: Change SQL compatibility version on VIDIZMO databases to 150 for SQL 2019.


Order of Script Executions

Below is the folder structure (under C:\Scripts in this example) and the sequence of script executions for transitioning database upgrade on VIDIZMO databases. You would need to execute upgrade scripts in the following order:

Note: You may use PowerShell ISE to execute PowerShell based scripts.


1. Folder name: VidizmoDBScripts  

  • File name: MainScript.ps1  

2. Folder name: NotificationDBScripts  

  • File name: MainScript.ps1  

3. Folder name: DeploymentScripts  

  • File name: Import-ApplicationConfiguration.ps1


VIDIZMO Application Database

Execute the MainScript.ps1 for upgrading VIDIZMO application database (VidizmoDB) and enter required information.

  • Folder name: VidizmoDBScripts
  • File name: MainScript.ps1


VIDIZMO Notification Database 

Execute the MainScript.ps1 for upgrading VIDIZMO notification database (VidizmoNotificationSystem) and enter required information.

  • Folder name: NotificationDBScripts
  • File name: MainScript.ps1


Database – Post Upgrade Deployment Scripts 

Here, you would need to update required parameters and run the script. Please see below:

  • Folder name: DeploymentScripts
  • File name: Import-ApplicationConfiguration

Parameters:

  • [String] $applicationConfigurationFilePath = "C:\Scripts\DeploymentScripts\",  
  • [String] $sqlserver = “<SQL Server hostname or IP Address>”,  
  • [String] $database = "<Main application database name>",   
  • [String] $user = "SQL user name",
  • [String] $password = ‘SQL password’  


Note: We strongly recommend backup your VIDIZMO databases prior to make new changes.


Conclusion - Database Upgrade 

All scripts should execute with valid information and by following the given execution order to successfully complete VIDIZMO database upgrade.


Step-2: Upgrade VIDIZMO Web Application 

To complete the web application upgrade, web application is redeployed with an upgrade package on the web application server. In this example, we are using C:\VIDIZMO for deploying upgrade on an existing VIDIZMO web application server. 


Note: VIDIZMO support team shall provide the web application upgrade package.


Application Upgrade Package 

The application upgrade package contains new application files in form of “VIDIZMO.zip” compressed file. You would need to extract the contents of “VIDIZMO.zip” compressed file. The “VIDIZMO.zip” compressed file will extract following folders:

  • Application
  • Players


Application Server Upgrade Procedure 

Below is the step-by-step process of upgrading your VIDIZMO web application server: 


Note: Make sure to Unblock the downloaded zip file before you extract it. Right click the downloaded zip file, click properties from drop down menu to open properties, and check the box that says “Unblock”. Click Apply and Ok to confirm changes and close the properties dialog box.

  1. Download and extract the application upgrade package on your VIDIZMO web application server. 
  2. Stop VIDIZMO Caching Service. 
  3. Stop VIDIZMO Notification Service. 
  4. Stop VIDIZMO Scheduler Service. 
  5. Stop IIS service (W3SVC).
  6. Rename the existing “Application” folder in your VIDIZMO directory e.g. “Application.old”.
  7. Copy the new “Application” folder to your VIDIZMO directory e.g. “C:\VIDIZMO\Application\”.
  8. Copy the “Players” folder to your VIDIZMO directory e.g. “C:\VIDIZMO\Players\”.
  9. Install IIS URL Rewrite module.
  10. Start VIDIZMO Caching Service.
  11. Start VIDIZMO Notification Service.
  12. Start VIDIZMO Scheduler Service.
  13. Start IIS service (W3SVC).


Encoder Server Upgrade Procedure 

Below is the step-by-step process of upgrading your VIDIZMO encoder server: 


Note: Make sure to Unblock the downloaded zip file before you extract it. Right click the downloaded zip file, click properties from drop down menu to open properties, and check the box that says “Unblock”. Click Apply and Ok to confirm changes and close the properties dialog box.

  1. Download and extract the application upgrade package on your VIDIZMO encoder server. 
  2. Stop VIDIZMO Workflow Service. 
  3. Stop VIDIZMO Scheduler Service. 
  4. Rename the existing “Application” folder in your VIDIZMO directory e.g. “Application.old”.
  5. Copy the new “Application” folder to your VIDIZMO directory e.g. “C:\VIDIZMO\Application\”.
  6. Start VIDIZMO Workflow Service.
  7. Start VIDIZMO Scheduler Service.


Step-3: Post Deployment/Upgrade Tasks 

In this section, we will do post deployment steps to complete the upgrade. 

  1. Copy your current application version: Navigate to C:\VIDIZMO\Application\Web\wwwroot and open “Version.txt” to copy the current application version.
  2. Update application version in database: To update the application version, open SQL Server Management Studio and connect your VIDIZMO databases. Expand VidizmoDB, expand Tables, right-click on dbo.ApplicationConfiguration > Edit Top 200 Rows.
  3. Update the Value for Key “ApplicationVersion” with the version number we copied from “Version.txt” in the previous step.
  4. Update the Value for Key "CacheServerList" with the hostname or IP address of caching server. You can add multiple hostnames or IP addresses (comma separated).

Note: We strongly recommend backup your VIDIZMO databases before making changes.

Step-4: License Activation

In this section, we explain the process of license activation for both Application and Encoder server systems: 


Note: You would need to truncate the ServerLicense table in VidizmoDB database to clear previous license information before you add new licenses.


Note: After completing the license activation process (below), you must need to restart VIDIZMO Scheduler Service on your VIDIZMO application and encoder servers to ensure they obtain license information for successful software activation.


Follow below steps to complete license activation on both web application and encoder server systems:


Note: You should follow below steps in sequence (in step-by-step order).

  1. Open your license activation URL. Your license activation URL is:
    • https://<Your VIDIZMO URL>/views/static/activate-license.html
  2. VIDIZMO team shall provide the License Keys needed to activate the web application and content processing systems.
  3. Activate your product package by entering the License Keys or uploading the License files provided to you by the VIDIZMO team.
  4. Add new license and activate it for Content Processing Server.
  5. Add new license and activate it for web application server.

C:\Users\james.corden\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\29A4C409.tmp

  • Once the license activation is completed, open your portal website, and login with your admin user account.
  • Go to the navigation menu and then go to Control Panel > Application Configuration > Cache.
  • You will need to update the local IP Addresses or hostnames of the caching servers in the Cache as per the screenshot. The list is comma separated.
    Note: This step is not needed if you have already updated hostnames or IP addresses of your caching servers in CacheServerList key, in dbo.ApplicationConfiguration table in the main application database.

C:\Users\james.corden\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\654A0BFF.tmp


In case of issues or concerns, please contact support@vidizmo.com and our support team will get back to you. 

--End of document--