Cross database or cross connection function differences?

Answered

Hi all, I can nicely do a Ctrl-D diff between two different functions / routines in the same database.  However, I tried two different functions in two different databases within the same connection and also tried two different functions in two different connections and both didn't work.  Is there a way to do diffs like that?  I'm using DataGrip 2019.3 release.  Thanks!

3 comments
Comment actions Permalink

Scott Murawski,


It works for two different schemas:

 

It works for different connections for the same db engine:

It works for for different db engines:

 

Am I missing something? Could you provide more detailed description, provide an example?

0
Comment actions Permalink

Hi Vasily,

 

Thanks for the info, that is exactly what I was hoping for.  I discovered with my situation (using PostgreSQL connections), when using two different DB connections and also two different databases in the same connection, for some reason when "Ignore source code" is checked, then it says there's "Nothing to show" in the upper pane of the diff window.  When it's unchecked it looks like it works just fine, whew!!  With 2 functions in the same database, the Ignore source code doesn't seem to do anything.

 

What does the Ignore source code mean?

 

Thanks!

Scott

 

0
Comment actions Permalink

Scott Murawski,

Ignore source code option helps you to ignore source code of database object if you're comparing object in different database engines. For example, to compare function signature in PostgreSQL and Oracle.

0

Please sign in to leave a comment.