Please tell me the best way to replicate data(one database only) between sql server 2008 r2 to sql server 2012 every hour.
Replicated Database on sql 2012 should be read and write.
Because your Secondary server is writable and is not merged to Primary. I would suggest to go for SSIS incremental load. Implement CDC in your primary server and incremental load into secondary. Going with replication, will need additional care and may cause latency\blockages in you scenario. Going with SSIS will give you control on job execution as per your requirement.
Ultimately it depends on data size and how frequently Primary is updated.
21 People are following this question.