Hi,

thank you for your replies.

I am considering the SSIS solution.
I would like to have the data migration periodically (let's say every 10 min).

I would like to copy only the record not already in the destination report database.
Should I filter the records in a sql query not copying the primary keys already in the destination table, or there is a better way?

furthermore, I would like to reflect the source database records changes in the destination database corresponding record.
I can't think a way to to this rather than adding a timestamps column (let's call it LastModified) for each table in the source database (let).

Is this the right way?