Run SQL Queries and compare results
We have a scenario where table ‘abc’ in database1 is split to new tables ‘def‘ , ‘ghi’ and ‘jkl’ in database2. It is very complicated to map the tables, columns and choose a stable primary key to verify the new tables with the old table.
And so we need to be able to join the tables to generate the data to verify old and new tables.
It would be very nice to have a feature to run the query for database1 and query for database2 and compare the results.
AdminDavid Atkinson (Admin, Redgate) commented
What you could try is to create a view in database2 that does the necessary join, and map the table against the view. Would that work?