I have a SQL Server database and an Oracle database containing tables that should have identical row counts and identical data stored within each field of each row.
Is there a tool available I can use to check that these two sources contain exactly the same data? Row counts are not sufficient for my customers' peace of mind.
If the tables are identical in structure save for one additional field on the SQL side, will the product function?
Many thanks for your suggestions.