WurzelGummidge
Technical User
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 ?
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 ?