How can we help you today? How can we help you today?
GeeOh
Activity overview Badges (0) Posts (0) Comments (2)

Activity overview

Latest activity by GeeOh

Hmmm - I wrote a lengthy response which looks to have been removed from the forum? / comments
  1. Community
  2. SQL Data Compare
  3. How to compare 2 tables with different keys?
Hmmm - I wrote a lengthy response which looks to have been removed from the forum?
0 votes
Alex B said: Hi @GeeOh, There isn't a facility within the product to compare the results of a script that is run I'm afraid -unless you dumped the results from source and target into new tables that is. Regarding the keys - is it that the columns and keys are not named and ordered the same?  Are you not able to map the columns and choose a custom key to compare on between two (or more) columns that make a unique record to make the comparison?  See this page for more details on mapping columns and setting the comparison key: https://documentation.red-gate.com/sdc/setting-up-the-comparison/selecting-tables-and-views Kind regards, Alex Hi Alex, Thanks for the response. That's a shame about the script result comparison. As for the key columns, the columns are named the same however they keys values are different on a row level for their corresponding facts. I don't know how familiar you are with dimensional modelling, but if you've not had much experience with it, then it might not be something for you to easy conceptualise without me giving a lengthy explination of how facts and dimensions work together. I've attached an imagine. In the image I am trying to compare 'FactA' table across 2 environments. Fact1... Fact2... Factn are never unique so they cant be used as keys. One way would be to use script folders and code a local virtual table then populate it with static data from a query: https://documentation.red-gate.com/sdc/working-with-other-data-sources/working-with-scripts-folders. With over 200 tables, this method is not viable for me. I'm now thinking that the only viable solution is to raise a request to our Database Administrators and create the views from the Fact to Dimension queries. Maybe redgate should think about implementing a simple query to query compare across 2 servers? Thanks. / comments
  1. Community
  2. SQL Data Compare
  3. How to compare 2 tables with different keys?
Alex B said: Hi @GeeOh,There isn't a facility within the product to compare the results of a script that is run I'm afraid -unless you dumped the results from source and target into new table...
0 votes
Total activity
3
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1