Activity overview
Latest activity by DENTSPLY
Thank you for the reply David.
Yes, if I could create a view to join the tables, that would allow me to compare them. However, since the source tables exist in our Production database, I am wary of adding any "unnecesary" objects just for comparison purposes.
However, that does bring up an idea. Is it possible to create a temporary view within SQL Data Compare that can be applied over both the source and destination databases, then the underlying tables compared based on that view? This way, the source tables would not be altered in any way, however the envelope/header/detail relationships could be easily compared.
If that is not an option at this time, I would like to make a request to add that feature. Please let me know if there is a formal process I need to go thorugh to make that request.
Thank you again,
-John Norcott / comments
Thank you for the reply David.
Yes, if I could create a view to join the tables, that would allow me to compare them. However, since the source tables exist in our Production database, I am wary o...
Thanks for your reply Chris.
I understand I can use a WHERE clause to limit the data I am comparing, but I still fail to see how I can use that as the comparison key, because the detail_ID field will still hold different values across environments.
The only thing I can think to do is create a view that distributes the unique field from the envelope table to each row of the header and detail tables. However, then there becomes an issue of creating a cartesion join during the comparison... Also, it would be preferable to do this without modifying the production database.
The best solution I can find so far (and I'm not saying it's really a good one) is to compare the envelope table based on the unique field. Then, loop through each record in the envelope table that passed the comparison, obtaining the associated header records and comparing them. Then again, loop through those header records and obtain and compare the associated detail records. But to do that, I really need to use custom code and straight SQL statements. I don't see any way to do that in SQL Data Compare, is there?
Thanks,
John / comments
Thanks for your reply Chris.
I understand I can use a WHERE clause to limit the data I am comparing, but I still fail to see how I can use that as the comparison key, because the detail_ID field wi...
Header - Detail comparison
Is there a way to compare tables based on values in OTHER TABLES?
I'm looking for a way to compare envelope-header-detail tables between production and test databases. The issue is that all of the...