Oracle schema comparison

Hi all,

I'm trying to find a way to compare two schemas in Oracle using DataGrip, but no luck. Am I missing something?

0

OK, sorry about that. Looks like I need to pick two schemas for this menu to become available.

Another question I have in this case - is there a way to have a tree with changes description as in TOAD and also to be able to pick objects to compare instead of full schema comparison?

 

 

0

Hi,

Do you mean comparison result changes or just changes in current schema?

Thank you.

0

Hi Vasily,

 

Here's what I mean

For example, I have the same schema in two different oracle instances (DEV vs TEST). And I want to build migration script for that.

1. I pick two connections in Datagrip and choose "Compare..." context menu item

2. Before comparison occurs I would like to pick objects to compare. For example, I would want only Views and Grants. Or only Packages.

3. After comparison is performed I would like to be able to see results of comparison in a way as it is on the screenshot above.

- Object which are only in First schema

- Objects which are only in Second schema

- Objects which are in both, but differ

 

And each of these groups have differences grouped by DB object type.

After that I could just check/uncheck necessary objects to build migration script.

Hope this makes sense. Let me know if more examples or clarifications needed.

 

Thank you.

0

Hi,

You can track https://youtrack.jetbrains.com/issue/DBE-298 to see the progress.

Thank you.

0

请先登录再写评论。