Question on Snapshot replication

Last Post 21 Apr 2004 11:58 AM by Rich_bailey. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Rich_bailey
New Member
New Member

--
21 Apr 2004 11:21 AM
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.
Rich_bailey
New Member
New Member

--
21 Apr 2004 11:58 AM
RM, Thanks for the great answers. Can you go into it replacing the data a bit more. My main concern is that if a query run at the right moment will have data that is missing (ie an empty table vs just not up to date)
Rich_bailey
New Member
New Member

--
21 Apr 2004 12:24 PM
Ok, so if it drops the tables there is a chance of the query trying to hit a not existent table and breaking. Is transaction or merge replication better for this.

How are people with huge data warehouses doing this when they need the data and reporting online all the time?
You are not authorized to post a reply.

Acceptable Use Policy