I have 2 servers
1) Production Server 2) Reporting Server
I create seprate tables for reports at production sever. I fill those table from stored procedure thru sql job daily. First i truncate the tables then insert whole data in reporting tables each time. So now i have to implement replication to replicate the
reporting tables data to reporting server database. I wan't to know which type of replication is used (Snapshot, Transactional, Merge).
View Complete Post