Compare Table Data Different Schema

[GRAYTech]

I'm trying to compare table data from a different schema owner. It's possible to select a different 'user' in the source database but not in the target session.

Is there a way to do this in version 8.0.2.1505 ?

Thanks.

 

[Marco Kalter]

You can select the user on the first page of the Compare Table Data tool, independent of the current connection. You can also make the target connection on this page.

On the 2nd (options) page you can optionally select a target schema. If you omit this, the schema of the target connection will be used.