/
Velocity Database Migration Video Guide

Velocity Database Migration Video Guide

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 /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

Use Velocity; declare @new nvarchar(50), @old nvarchar(50), @operatorName nvarchar(50), @appPath nvarchar(200), @domain nvarchar(200), @sqlserverinstance nvarchar (50),@VelocityUsersGroup nvarchar(50), @VelocityServicesGroupPath nvarchar(50), @VelocityServicesAccount nvarchar(50), @VelocityServicesGroup nvarchar(50) ; set @new = 'WIN10' set @operatorName = 'ADMINISTRATOR' set @appPath = 'C:\Program Files (x86)\Identiv\Velocity' set @domain = 'WIN10' set @old = (select top 1 computername from registry where Application = 'sdserver') set @sqlserverinstance = 'WIN10\IDENTIV' ----------------3.8.5 or newer only------------ set @VelocityUsersGroup = 'Velocity Users' set @VelocityServicesGroupPath = @domain set @VelocityServicesAccount = 'VelocityServices' set @VelocityServicesGroup = 'Velocity Services' ----------------------------------------------- if @domain = @new begin update MiscProperties set Value = '0' where Name = 'UseDomainAuthentication' update MiscProperties set Value = @new where Name = 'AuthenticationPath' update Operators set DirectorySource = '\\' + @new end else begin update MiscProperties set Value = '1' where Name = 'UseDomainAuthentication' update MiscProperties set Value = @domain where Name = 'AuthenticationPath' update Operators set DirectorySource = '\\' + @domain end if exists (select * from MiscProperties where Name = 'VelocityUsersGroup') begin update MiscProperties set Value = @VelocityUsersGroup where Name = 'VelocityUsersGroup' end if exists (select * from MiscProperties where Name = 'VelocityServicesGroupPath') begin update MiscProperties set Value = @VelocityServicesGroupPath where Name = 'VelocityServicesGroupPath' end if exists (select * from MiscProperties where Name = 'VelocityServicesAccount') begin update MiscProperties set Value = @VelocityServicesAccount where Name = 'VelocityServicesAccount' end if exists (select * from MiscProperties where Name = 'VelocityServicesGroup') begin update MiscProperties set Value = @VelocityServicesGroup where Name = 'VelocityServicesGroup' end update Registry set value = @sqlserverinstance where Property in ('ServerName','SQL Server') update Registry set ComputerName = @new where ComputerName = @old update Registry set Value = @new where Property in ('RemoteServerIP','RemoteIP','SDServer') update Registry set Value = @appPath where ComputerName = @new and Property = 'AppPath' update Servers set Server_Name = @new update ServerExtensions set RemoteComputerName = @new update Workstations set WorkstationName = @new where WorkstationID = 1 update ServerPorts set Enabled = 0 IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ScheduledServiceTasks' AND COLUMN_NAME = 'ComputerName') BEGIN update ScheduledServiceTasks set ComputerName = @new where ComputerName = @old END if not exists (select Name from Operators where Name = @operatorName) begin insert into Operators(Name, DirectorySource) values (@operatorName, (select top 1 directorysource from Operators)) insert into OperatorsToGroups (OperatorID, GroupID) values ((select operatorid from Operators where Name = @operatorName), 1) end

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

Related content