Clever Geek Handbook

Can RedGate Data Compare use connections?

Using Reddate SQL Data Compare 9.

This is a simplified example of what I want to do. I have the following tables:

Product (ProductId, ProductName)         
ProductDetail (ProductDetailId, ProductId, OtherField)

The Id column in both tables is primary keys and autoincrement (identification). The product has a unique constraint on ProductName. I have a production system and a test system and I would like to use Data Compare to synchronize the ProductDetail tables of the two systems.

The problem is that the id columns of the two systems are out of sync. A product called "Bananas" may have an ID of 1000 in production and an ID of 6 in the test.

I would like to compare using a join - instead of using a key that is only columns in the ProductDetail table, I could compare based on a combination of fields using the Product and ProductDetail tables.

I don't see any way for more than one table to participate in the comparison in the data comparison UI. Is this what I am trying to achieve?

+3


source to share


1 answer


using a query with your desired join condition, create a table with the results on each db and use rg to compare these tables



+2


source






More articles:


All Articles