Thank you all for the replies.

We decided to develop our own app that will do this. Essentially what it does is setup triggers in each table that needs a sync....

Here's some more info

Agreed, however I'm looking for a product that lists all tables in two databases and I just choose the from table to table from column to column...

I'm not sure if I understand. Are you saying the replication service will be able to do the transformation of the data? Or you are suggesting to move the data...