COMPARE TWO PROJECT: PROD AND TEST

sangi1981 · Post by **sangi1981** » Fri Oct 18, 2013 7:40 am

Hi all,
is there a tool in Datastage or in Information Server to compare all the jobs of two project?
If not, is there some workaround or good practice to achieve the same result?
Thanks in advance,
Sandro

ray.wurlod · Post by **ray.wurlod** » Fri Oct 18, 2013 2:23 pm

You can compare ONE job across projects. There is no tool that will do them all. Some will suggest exporting the jobs from each project and comparing the DSX files with a command such as diff.

chulett · Post by **chulett** » Fri Oct 18, 2013 2:53 pm

... but that way leads to madness.

vmcburney · Post by **vmcburney** » Fri Oct 18, 2013 4:23 pm

I have found win diff to be good at comparing export files, it might be easier to compare a category at a time since it is no good if the files go badly out of alignment. You can also do a search on modification dates to spot suspicious job edits.

chulett · Post by **chulett** » Fri Oct 18, 2013 5:50 pm

Yah, if you have an 'intelligent' comparison tool you might have better luck. I own a perpetual license for UltraCompare which is quite nice.

sangi1981 · Post by **sangi1981** » Sat Oct 19, 2013 3:32 am

Hi gurus,
thanks for your replies.
I tried unix diff command on .dsx: yes, madness!!!!

Ok, I think I'll search for UltraCompare or some similar.
Sandro