We are looking into replication for a reporting server. It appears to be that snapshot replication will work the best for us (less workload and periodic updates of the exact data).
However, we have questions in mind such as -
During a snapshot replication does it ever removed data (ie empty the table and replace all the data with the snapshot) so that at some exact point there would not be data in the table.
Does it replace the exact schema, meaning we could not have special reporting indexes?
Is snapshot less likely to have an 'out of sync' issue since it is supposed to be exactly like the original data?
Thanks in advance.