Tool to compare database table content in two systems (transactional data)

[fabiankegel]

Hi,

I am looking for a standard functionality, which can be used to compare the content of a database tables in two different systems (using RFC).

I already tried to use the customizing comparison tool SCU0, which runs, as expected, into memory problems.

Is there any tool, which is also able to compare database tables with a high number (> 3.000.000) of data sets.

Thank you for your help,

Fabian Kegel

[Former Member]

Hi Fabian,

I asked our SAP DBA expert and he suggest to use the DB tools instead of SAP transaction. In Oracle and DB2 (open env.) you can use the minus "-" operator to compare tables.

for faster operation you can copy the remote table into the local DB server.

Good luck