RE: Automation Designer question

Hi Roger,

Do you realize I'm referring to very simple Automation Deisgner apps,
right? Basically just exporting a dataset from a DB to an Excel
spreadsheet and mailing that spreadsheet to someone daily. Your answer
leads me to think you're thinking of something a lot larger and more
complex. I fear I wasn't very clear and made it sound a lot more
complex that what it really was.

I appreciate the thoughts though and your willingness to help!  Were
this Friday, I'd tell ye that yer a fine man and not a landlubber, but
alas it's a Monday and no pirate talk for me. :)

John

From: [email protected] On Behalf Of Simoneau, Roger
Sent: Monday, January 16, 2012 11:13 AM
To: John Graves; '[email protected]'
Subject: RE: [toad] Automation Designer question

I imagine it really depends on your apps.

Let’s say you have java apps coded to target the actual host/port
names.  Then you need to alter the apps (or take the existing server
off line, bring up the new server on the existing host/port, I
wouldn’t recommend this solution).  Caveat: I’m not a java developer
so I’m thinking logically on limited information for that problem.

If your apps are coded for the alias in the tns file, then I imagine
it’s as simple as changing the tns file to give the new host the
existing alias – while removing the alias on the old host of course.

Those are two possibilities to highlight: it depends.  It would really
be more helpful if you could outline the specifics of how the apps
access the databases.  That alone would likely point you in the
direction of a solution.

Roger S.


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/