Devart Forums

Hi there.

Please help me to figure out why the check boxes on the column mapping screen are not available.

Thanks

Could you please provide us a screenshot demonstrating this issue?

You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.

Sent

Unfortunately, we haven't received it. Could you please also try sending it to alexaATdevartDOTcom ?

sent to alexaATdevartDOTcom

Thank you for the reply.

We have received an e-mail from you and are currently investigating the issue. We will get back to you with a result as soon as possible.

This is a limitation of dbForge Data Compare for Oracle when working with backups. The unique key (PRIMARY or UNIQUE) is automatically set as the comparison key.

Please let us know if any questions arise.

Our client's ERP system has vast majority of its tables with no primary key or index.
And we are not allowed to add any on the "Live" server.


We would be very much attracted by a "compare database vs backup using ad-hoc keys" feature.

Will this limitation be lifted in future?

This is quite a complicated functionality that requires emulating the server's sorting. Such a sorting will take a lot of time and system's memory. Theoretically, it's possible, but we do not see the practical use in such a feature.

As a workaround, you can deploy the backup onto a local server and perform comparison between the local and live servers.

Ok. No probs.

Thank you.

Please let us know if any questions arise.