sql server replication: I would like some feedback on which publication type is best for my scenario.
I am trying to decide between a Snapshot publication and Transactional
publication.

I have about 3 tables I am going to replicate in one publication. Each has
approx 6 million rows. A set of updates are done nightly to these tables at
the Publisher ranging from several thousands to 100k records affected during
a 4 hour period.

Because it is acceptable to have data that is out of date at the subscriber,
I thought it would be best to use Snapshot because I can run it once a night
after the publisher finished its updates and the Publisher will not have to
keep track of thousands of changes that take place. However, since the tables
are fairly large, I dont know what to do as it may take some time to
replicate and it may not be a good practice overall.

What do you suggest ? Why?

Thanks for any advise you can give.

FYI, both the Publisher and the Subscriber are on the same network, running
a 3Ghz Intel Xeon Processors on Dell PowerEdge 2600 servers.

use transactional. Only the changes will be replicated. Snapshot
replication will require that the entire tables be resent each time.

If the changes are done through procs, replicate the execution of
stored procedures for optimal performance.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com