I have a specific question regarding DB migration. Let us say If source DB contains 10 tables, which we need to migrate the data to a single table in destination (in our case, source is oracle, destination is sybase).
From the scope in DB migration testing // All data related to a particular entity is loaded in each relevant table in the target database// it is not possible to test all the records manually. Do we have any specific tool to compare the source and destination data in this case? Actually I tried long back with DBSOLO, but this tool can only compare the data If source and Destination DB schema's are equivalent and number of tables should be same