Velocity Database Migration Video Guide

For a written guide see the following page

Step 1: Backing Up the Velocity Database

https://youtu.be/7cpvIqraOZ0?feature=shared

Step 2: Copying Velocity Archives

Velocity Archive Permissions Commands

Take ownership of the Velocity Archives

TAKEOWN /F "C:\Program Files\Microsoft SQL Server\MSSQL15.IDENTIV\MSSQL\DATA\VelocityArchive*.*" /A /R

Give full control to the local Administrators group

icacls "C:\Program Files\Microsoft SQL Server\MSSQL15.IDENTIV\MSSQL\DATA\VelocityArchive*.*" /grant Administrators:F /T

Give full control to the Velocity Services account

icacls "C:\Program Files\Microsoft SQL Server\MSSQL15.IDENTIV\MSSQL\DATA\VelocityArchive*.*" /grant VelocityServices:F /T

 

Step 3: Copying Velocity DAT Encryption Files

Step 4: Export The Velocity TLS Certificate

Step 5: Restoring Velocity Database

Stept 6: Update Velocity Tables Post Restoral

Velocity migration script

----------------------------------INSTRUCTIONS--------------------------------------------
-Modify the following set statements. Leave the single quotes. Then run the script below.
--set @new = 'pcHostname'
--set @operatorName = 'UserNameOfInstaller'
--set @appPath = 'Velocity installation path'
--set @domain = 'Shortend domain name'
--set @sqlserverinstance = 'found in SQL Server Management studio'

-------------------------------3.8.5 or newer only-------------------------------------------
--Leave default values or enter custom values if applicable. This section will be ignored on 3.8.4 or older.
--set @VelocityUsersGroup = 'Velocity Users'
--set @VelocityServicesGroupPath = @domain or 'pcHostName'
--set @VelocityServicesAccount = 'VelocityServices'
--set @VelocityServicesGroup = 'Velocity Services'
----------------------------------INSTRUCTIONS--------------------------------------------

Click expand to see SQL Script

Step 7: Setting SQL User Permissions

Step 8: Setting Velocity Archive Permissions

See above step 2 for the commands.

Step 9: Import Velocity DAT Encryption Files

Step 10: Import Velocity TLS Certificate

Step 11: Cutting Over to New Production Server