SQL – Change Volume informations in database

After migration from one to another server or in case of cloning you must change some volume data in database:

Use at your own risk!

-- shows volume informations
select * from PIMANVOLUME

-- update volume node_name
UPDATE [PIMANVOLUME] SET [pnode_name] ='servernameNew'

-- update volume physical path (old to new)
UPDATE [PIMANVOLUME] SET [pwnt_path_name] = REPLACE([pwnt_path_name], 'E:\plm\TcVolumes\volume1', 'D:\plm\TcVolumes\volume1')