ビデオヘルプ

SQL update part of an entry

作成: 20 Feb 2013 • 更新: 20 Feb 2013 | コメント数: 4
GertjanA の写真
この問題は解決されました。 ソリューションを参照してください。

Hello all,

Not really related to EV operation.

I am in the proces of preparing for a DR test
The indexes are running on file-servers.

I have to update rows in SQL.

The command I use (amongst others) is as below.

UPDATE [EnterpriseVaultDirectory].[dbo].[IndexRootPathEntry]

SET IndexRootPath = 'server92513\EVIndex\Location1\EVIndex\index1'

WHERE IndexRootPath = '\\server95513\EVIndex\Location1\EVIndex\index1'

I have about 240 rows to change.

Is it possible within SQL, using some nifty selection option to change only the value 'server92' to the value 'server95'? This would leave less room for errors, as indexlocations are regularly moved, and several are added also. As you can guess, I am not a SQL guru :-). Any ideas welcome!

Thanks,

Gertjan

コメント コメント数: 4最新のコメントを表示

Rob.Wilcox の写真

Does this help:

update indexrootpathentry
set indexrootpath = '\\server92'+ substring(indexrootpath, 10, 500)
 
 
Replace the string with what you want to do.. replace the 10 with the number of characters of the current name (eg 10th char in)..  500 leave as is, it's just an arbitrary large number to get all the characters.
ソリューション
GertjanA の写真

Works like a charm!

Thank you, Gertjan, MCSE, MCITP,MCTS, SCS, STS
Company: www.t2.nl

www.quadrotech-it.com

www.symantec.com/visi

GertjanA の写真

Damn, your good. Thanks Rob.

I'll check before setting solution

Thank you, Gertjan, MCSE, MCITP,MCTS, SCS, STS
Company: www.t2.nl

www.quadrotech-it.com

www.symantec.com/visi