DB Comparison Tool

[WurzelGummidge]

Hi all,
I have 2 sql databases where 1 loads info from the other on scheduled jobs.
I am interested in investigating if there are comparison tools that allow me to compare things like stock tables - ie: DB1 TABLE 'stock' FIELD 'product' [where product = 'xyz' returns 23 , but
DB2 TABLE 'stock' FIELD 'product' [where product
= 'xyz' returns 10 , so, update DB2
I have seen some tools but they seem to rely on EXACT table & field name replication. I would like to maybe map fields and tables to do the compare ?

 

[royjimenez]

u can make a replication and if u need to personalize your replication, i can make a store procedure to decide what u need to replicate.

 

[WurzelGummidge]

Hi royjimenez,

I don't need to REPLICATE, i need to COMPARE a live back-office database with a live CRM database then
UPDATE IF value in DB1.Field x <> value in DB2.Field x
WHERE DB1.unique = DB2.unique

 

[JayKusch]

May need a tool like SQL Compare to do that kind of updating.

Thanks

J. Kusch