TABLE OF CONTENTS


Overview 

The main components of VIDIZMO consist a web application and databases. To upgrade the solution, both web application and the databases would need to be upgraded to the latest version.


Step-1: Database Upgrade 

The process of database upgrade is done by running upgrade scripts on your VIDIZMO databases. We recommend you execute the upgrade scripts on the server that hosts your VIDIZMO databases (SQL server). See below requirements for upgrade scripts:

  • Powershell 4.0 or greater
  • SQL user account with dbowner permissions on VIDIZMO databases


Database Upgrade Scripts

The upgrade scripts are executed in the following order:  

  1. VidizmoDBScripts.zip
  2. NotificationDBScripts.zip
  3. 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
  • File name: Import-ContentFormat.ps1
  • File name: ImportDefaultPatterns.ps1
  • File name: InsertDefaultTemplates.ps1
  • File name: Import-Permissions.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:


Update Application Configuration:

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

Parameters:

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


Update Content Formats:

  • Folder name: DeploymentScripts
  • File name: Import-ContentFormat.ps1

Parameters:

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


Import Default Patterns:

  • Folder name: DeploymentScripts
  • File name: ImportDefaultPatterns.ps1

Parameters:

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


Insert Default Templates:

  • Folder name: DeploymentScripts
  • File name: InsertDefaultTemplates.ps1

Parameters:

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


Update product permissions:

  • Folder name: DeploymentScripts
  • File name: Import-Permissions.ps1

Parameters:

  • [String] $permissionsPath = "C:\Scripts\DeploymentScripts\Permissions",  
  • [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 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 Web Application and Encoder Server

To upgrade application and encoder systems, you would need to replace the existing VIDIZMO directory with the updated one provided by VIDIZMO support team. In this example, we are using C:\VIDIZMO for deploying upgrade on existing VIDIZMO web application server and encoder systems. 


Note: VIDIZMO support team shall provide the web application upgrade package for deployment/upgrade of VIDIZMO application and encoder systems.


Upgrade package for app and encoder systems

You will receive the upgrade package in form of “VIDIZMO.zip” compressed file. You would need to extract “VIDIZMO.zip” in order to proceed further.


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.


Application Server Upgrade Procedure 

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

  1. Download and extract the application upgrade package on your VIDIZMO web application server. 
  2. Stop all VIDIZMO services (Windows services).
  3. Stop IIS service (W3SVC).
  4. Rename the existing VIDIZMO directory e.g. “C:\VIDIZMO.old\”.
  5. Copy the new VIDIZMO directory in C drive e.g. “C:\VIDIZMO\".
  6. Start all VIDIZMO Services.
  7. Start IIS service (W3SVC).


Encoder Server Upgrade Procedure 

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

  1. Download and extract the application upgrade package on your VIDIZMO encoder server. 
  2. Stop all VIDIZMO services (Windows services).
  3. Rename the existing VIDIZMO directory e.g. “C:\VIDIZMO.old\”.
  4. Copy the new VIDIZMO directory in C drive e.g. “C:\VIDIZMO\".
  5. Start all VIDIZMO Services.



Step-3: License Activation

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


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>/static/views/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 click "Activate" to activate it for web application server.

Note: Once you have activated the new licenses, you should remove the previous licenses from dbo.ServerLicense table in VidizmoDB database. You may review/screenshot the data in dbo.ServerLicense table before activating new licenses that should help remove the previous licenses later after activating the new licenses.


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

  • You will follow the same process for adding another license that can be used to activate the encoder server.
  • Once the license activation is completed, open your portal website, and login with your admin user account.


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


--End of document--