compare two tables row count from different DB's.

[kotlapullareddy]

Hello All,

I would like to understand the how to compare the two tables row count in knime?.
Let say,
I Have Table A in DB1 & same Table A in DB2 as well.

Now I need to compare count of rows from DB1.TableA = DB2.Table A then, if it’s equal nothing to do. if row count is not matching then update the DB2.Table A.

[izaychik63]

Take a look at

DB Merge — NodePit

node.
I assume you can put both dbs in one loop.
Loop over tables in db1 and merge them to db2.
No need to count rows.

[kotlapullareddy]

Thanks for info @izaychik63

Can I know, any best example to figured out how DB Merge works?.

[izaychik63]

See here

demo_db_migration — NodePit