Replication Comparison Chart for SQL2005

Anyone know of a chart on the Microsoft Site that compares all the
Replication types for SQL 2005?
Trans Shipping, Mirroring, Publication and Subscription and all that
stuff?
Here is a pretty good one on the Dell site.
www.dell.com/downloads/global/power/ps1q06-20050325-Sankaran.pdf
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
"jughead" <mike.aarset@.gmail.com> wrote in message
news:1174056604.344365.92450@.o5g2000hsb.googlegrou ps.com...
> Anyone know of a chart on the Microsoft Site that compares all the
> Replication types for SQL 2005?
> Trans Shipping, Mirroring, Publication and Subscription and all that
> stuff?
>

Replication

Hello,
Can anybody explain me here or can recommend me a good literature how the
replication works with its corresponding compononents and the course of
events of the replication?
thanks in advance
yours sincerely,
robert
with components i mean the virtual directory, publication, snapshot folder,
subscription, repldata folder in the SQL Server directory, etc...
yours sincerely,
patrick
|||Patrick,
currently books on line (BOL) is the best resource for
this sort of data. I have some links on
www.replicationanswers.com you might find useful.
Finally, keep an eye out for Hilary's book:
http://www.nwsu.com/0974973602p.html.
As for the snapshot folder and the repldata folder -
usually they are one and the same. The repldata folder is
an installation folder and is usually made available as a
share to subscribers. This is the folder that stored the
initial configuration textfiles, and datafiles if
selected. ODBCBCP is used to transfer the data to this
file. On initialization the contents of this folder are
applied to the subscriber by the distribution/merge agent.
Alternative snapshot locations are possible - removable
media such as removable disks, CD-ROMs, or in locations
other than in the default snapshot folder on the
Distributor, such as File Transfer Protocol (FTP) servers
which may be compressed, however the above is the default
behaviour.
HTH,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||are we talking SQL CE or SQL Server? SQL CE has a virtual directory which an
isapi filter runs in. The only other virtual directory used in replication
is when you are downloading a publication using ftp and have defined a
virtual directory on your ftp server.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"robert" <robert@.discussions.microsoft.com> wrote in message
news:553B67F1-EF21-480B-99EF-7EFE5B431313@.microsoft.com...
>
> with components i mean the virtual directory, publication, snapshot
folder,
> subscription, repldata folder in the SQL Server directory, etc...
> yours sincerely,
> patrick

Replicating structural changes

Hi,
Is it possible to replicate structural changes? I've been reading the
replication docs, and it looks to me that this is only possible using
snapshot replication (ie. not on the fly).
Any products that can do better replication (all additions/changes to
all db objects for a given db) than the natively supported?
Thanks,
Morten
Morten,
sp_repladdcolumn and sp_repldropcolumn can be used for most simple column
schema changes, and such changes can be done on the fly. You can't change an
existing (replicated) column directly - eg change the datatype from int to
varchar, but these 2 stored procedures can be used to make such changes
indirectly. Many other schema changes are not part of the replication
framework - eg adding an index or most constraints but these can be sent to
subscribers using sp_addscriptexec.
HTH,
Paul Ibison