Best approch to replicate data from one db to other db on same server
If the data in the reporting database does not have to be real-time, the I suggest you do not implement replication but instead go with log shipping.