One of the LAN servers accessed in various DS projects is getting replaced and a new name. My task is to change all instances of the server name within my projects from 'serverABC' to 'serverXYZ'.
To accomplish this I exported one of the projects in Manager, created a job to read the .hml file and EREPLACE the server names. Then imported the modified file, mass compiled all the jobs and rescheduled the jobs.
This was a small project but some of the others are much larger and contain only a few server references. Is there a way to capture only those jobs, sequences, and routines that have changed so I don't have to recompile and reschedule everything? Or perhaps a better way to make the change?
Thanks in advance for any suggestions!
Modify a dsx or xml file
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Parameters are used for jobs and sequences. Command Stages have the server name hardcoded. I don't think the command line can use the parameter.
I'm not sure why they didn't simply rename the servers. Then again, I don't think it's an issue for anything other than DataStage which they didn't realize was impacted until 2 weeks before the scheduled migration was to begin.
I'll look for Kim's scripts and go from there.
Thanks everyone!
I'm not sure why they didn't simply rename the servers. Then again, I don't think it's an issue for anything other than DataStage which they didn't realize was impacted until 2 weeks before the scheduled migration was to begin.
I'll look for Kim's scripts and go from there.
Thanks everyone!