Hopefully an easy one!!

I need to push out a new tnsnames.ora file for our Oracle client, I would also like to rename the existing one so it remains on the machine.

What would be the best way to do this with WPS, should I be looking at the movefile table, or a custom action or something completley different!?

Thanks in advance
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
You could both use the MoveFile table or a custom action.
I would go for the MoveFiles action to do the work for you.
Answered 11/16/2007 by: AngelD
Red Belt

Please log in to comment
0
You could both use the MoveFile table or a custom action.
I would go for the MoveFiles action to do the work for you.
With something as fundamental as TNSNAMES.ORA, I'd do it in script. That way, you can include tests to be sure your backup file got created, that the entry got added and that the new file was saved with a new date/time stamp. Not that I'm paranoid...

Also, if your working in-house, why on EARTH are you using a local copy of TNSNAMES.ORA? It belongs on a globally-accessible network share, read-only to users, with write access to a select group to a) eliminate the above issue and b) stop users interfering with it.
Answered 11/17/2007 by: VBScab
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity