SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Replication (Snapshot)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

boggyboy
Yak Posting Veteran

USA
57 Posts

Posted - 10/11/2012 :  10:06:47  Show Profile  Reply with Quote
is there any advantage of using SQL Snapshot Replication over a approach where I accomplish the same result with just a few SQL statements.. such as

DROP the destination table
SELECT INTO destination table FROM source table



Nick W Saban

boggyboy
Yak Posting Veteran

USA
57 Posts

Posted - 10/12/2012 :  05:56:27  Show Profile  Reply with Quote
Here is the answer:

Replication will only affect records added, updated or deleted since the last replication whereas Drop/Insert will of course affect all records. For smaller result sets this may not be an issue however if you’re looking at hundreds of thousands/millions or records, there could be a substantial impact on the database performance (especially if there are indexes involved). Also, Drop/Insert will result in larger transaction log activity than replication.

Nick W Saban
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 10/20/2012 :  19:23:21  Show Profile  Visit russell's Homepage  Reply with Quote
No. The snapshot agent copies ALL of the records, not just changes.

I still often choose snapshot replication for this task, particularly when there are many tables I need to copy on schedule.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000