Match procedures with vcs

[Ruudbern]

Sometimes we check if there is a difference between the source in our vcs and the source in our devellopment oracle user.

Is there a easy way/tool to do this?

 

[Marco Kalter]

You could use the CompareSource Plug-In for this. Assuming that the VCS version is somewhere on the file system as well.

 

[Ruudbern]

The compare plugin only compares the open window. I want to compare more than 1000 procedure, triggers etc. agains my filesystem. So the plugin would take to much time.

I now compare exports but its time consuming due to differences in trailing spaces, lines etc.

Any other tips/ suggestions?

 

[Marco Kalter]

Use the Export User Objects tool, use the "File per object" option, export the program units you want to compare, and run a script that performs a diff between the exported files and the VCS files.