Summary: sql-commands to change servers / server substitute

[harter]

Hi group.



It was a peace of hard work to make everything work the way I wanted it...



There was a big hinderance that has cost me a lot of time: If I am logged on
as a local admin everything is working fine, if I am logged on as a domain
admin it doesn´t proceed the dumpfile import....



Here´s the script I use to make a daily incremental copy of my vault and a
daily dumpfile import. Afterwards my script automatically changes all the
necessary sql-tables to change the server names:



############################################################################
####################################

xcopy /e /c /h /r /k /i /y /d
\\ip-address\cadbackup\Intralink-Backup-daily\daily_vault_1 d:\file_vault_1
>c:\temp\daily_vault-import.txt

d:
cd \File_Vault_1
del ilink_alt.dmp
del ilink_alt.dmp.lst
ren ilink.dmp ilink_alt.dmp
ren ilink.dmp.lst ilink_alt.dmp.lst


cd \data_server\intralink\export
call d:\data_server\intralink\export\ilink_import.bat manager
\\ip-address\cadbackup\Intralink-Backup-daily\daily_vault_1\ilink.dmp<c:\sql<br/>-script\prompt.txt

sqlplus /nolog @C:\sql-script\intralinksub.sql

############################################################################
####################################################


in sector "call..." <c:\sql-script\prompt.txt&quot; opens=" a=" textfile=" that=" only<br="/>contains the letter "y"
in sector "sqlplus" a sql-file opens with the following entries:


connect system/manager
update pdm.pdm_fileserver set fsvhost='neuerserver' where
fsvhost='alterserver';
update pdm.pdm_pool set poolhost='neuerserver' where poolhost='alterserver';
commit;
quit



Thanks for any help and have a great weekend!

Rainer





--

Rainer Harter

Systemadministration / IT-Sicherheit

Fraunhofer-Institut Physikalische Messtechnik IPM

Heidenhofstr.8, 79110 Freiburg, germany

Tel: +49 (0)761/8857-320 Fax: +49 (0)761/8857-224

E-mail: <">mailto:Rainer.Harter@ipm.fraunhofer.de>
Rainer.Harter@ipm.fraunhofer.de

www.ipm.fraunhofer.de