How can we help you today? How can we help you today?

Possible to compare different schemas?

Is it possible to compare objects from different schemas? Here's my scenario.

I have two different schemas with the same tables/views that I'd like to compare. Is there a way to do that?
davidsumlin
0

Comments

2 comments

Sort by
  • Evan Moss
    Hi David,

    Thanks for the post.

    You should be able to accomplish this by choosing the same database for the source and the target and then going to the "owner mapping" tab in the project options. By default, the schemas will be matched up with themselves, but you can unmap them and then map different ones to each other.

    Hope that helps.

    Regards,
    Evan
    Evan Moss
    0
  • davidsumlin
    Ahhh, for some reason I thought I looked there, but maybe I just didn't understand it correctly. Excellent, thanks! That solved my issue.
    davidsumlin
    0

Add comment

Please sign in to leave a comment.