Velocity Database Migration Video Guide
- Eduardo Bahena
For a written guide see the following page https://identivdocs.atlassian.net/wiki/spaces/HBI/pages/1940722855
Step 1: Backing Up the Velocity Database
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 /RGive full control to the local Administrators group
icacls "C:\Program Files\Microsoft SQL Server\MSSQL15.IDENTIV\MSSQL\DATA\VelocityArchive*.*" /grant Administrators:F /TGive 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.