Enhancement Request : Compare Tool Database/File
- Thread starter orca777
- Start date
That is indeed a nice idea. It is even relatively easy to create a Plug-In for this that saves the database source in a temporary file, asks for the file to compare, and launches ExamDiff utility that comes with PL/SQL Developer.
My idea exactly. Anybody? Otherwise I will have to do it myself...
ScottMattes
Member³
Right now I have some time on my hands (just spent the day getting around a line length limitation in Scale plug-in), so I could give it a go.
Thanks, you know where to find me if you need any help or when you're done.
ScottMattes
Member³
I am planning to also allow the user to compare against the same named code in another schema.
I'll start today.
I'll start today.
Be careful not to rewrite the Compare User Objects tool...
Actually, that would be nice. The compare user objects tool just hangs when I open it and it always has. I think that it's gathering all objects in the schema or something until my PC runs out of memory - kind of a bummer. I've been waiting for it to work for a long time.
If we could just select one object in the browser and compare that with another database - that would work!
If we could just select one object in the browser and compare that with another database - that would work!
Does this happen when you open it or when you run the compare?
Would it be possible to choose the schema and DB to compare?
In our environment the objects on the test DB reside in a separate schema (same schema name as production DB) so the compare tool is useless for developers as it only allows comparison of your current schema to another DB. Currently, our only way to compare code is to save both versions to local files and run a 3rd-party app for comparison.
In our environment the objects on the test DB reside in a separate schema (same schema name as production DB) so the compare tool is useless for developers as it only allows comparison of your current schema to another DB. Currently, our only way to compare code is to save both versions to local files and run a 3rd-party app for comparison.
You can compare any 2 schema's, if you have the password. Connect as one in PL/SQL Developer, and compare to the other.
Matthew James
Member
Any plans to change this to allow the schema to be specified separately ?
We have a configuration where the production passwords are not known to developers, so we can't log on to the schema owner.
There was a post from Feb last year saying that this change was on the enhancement list - is it likely to go ahead ?
We have a configuration where the production passwords are not known to developers, so we can't log on to the schema owner.
There was a post from Feb last year saying that this change was on the enhancement list - is it likely to go ahead ?
We'll definitely look into this for 6.0 and implement it if it's not too difficult (which I can't imagine).
Sergei.Agalakov
Member²
Had anybody completed a tool to compare packages in database with files? Just yesterday I had to compare more than 20 packages in database with files in Source Safe to verify that they are identical. I had to manually save packages to files in temporary directory and compare them one by one with the files from Source Safe.
I should be automated long time ago really.
I should be automated long time ago really.
Marco van der Linden
Member³
There is the CompareSource plug-in by Scott Mattes, which will allow you to compare source code against file or other db source. Very useful indeed.
Similar threads
- Discussion
