DSXchange

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!

Kim Duke posted some scripts to search for a particular string in a project. Use that script and change only the required jobs and reschedule them.

Hmmm... why is this not a job parameter?

Or reuse the existing LAN name to the new one and new LAN to current name. In short, swap the names

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 would wager that they can. I don't have Windows and thus no 'Command' stage but the Execute Command stage can with a small trick which I'm guessing would work in the Command stage as well.