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!
![Question :?:](./images/smilies/icon_question.gif)
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!