Copy data among two database

Hi everyone,

I am looking for suggestions about synchronizing data among two SQL server database. I would want one db few tables to update the corresponding table on the second db. So it is essentially just one was update i.e from a source db to a target db and I want this to happen once ot twice a day only. Any suggestion on how to approach this will be highly appreciated.

Thanks