Change detection between projects

j.anderson · Post by **j.anderson** » Wed Feb 23, 2005 10:22 am

I am trying to write a script that can take a DSX file from our development server, and compare it to what is on the production server to see if any changes have been made. This will allow us to make sure all changes are documented before moving to production.

The DSX files have a Modification Date, however I have seen no such date I can compare to on the production side (i.e. in the repository). I can't think of another way to do this.

Do any of you do something like this? Is there some sort of way you know of that I can see if something has changed in a job?

Thanks!

ArndW · Post by **ArndW** » Wed Feb 23, 2005 10:58 am

Can you do an export from the production and then compare the flat files (you can use DataStage to do that

)?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Feb 23, 2005 11:01 am

You will need to change / remove the export header which contains project and server specific information and also some date + time lines.

kcbland · Post by **kcbland** » Wed Feb 23, 2005 11:56 am

See this post:
viewtopic.php?t=90672

You can use DS_AUDIT as a means of identifying what objects have changed in a project, but for internally on the object, you must do a .dsx comparison. However, this may not work because of the internal numbering scheme on object designs. The internal numbers change as you do things to a job design.