Hello,
Whats's the utility / advantages of the "Transactional publication with
updatable subscriptions"
thanks for your help!!!
nico
"pralnico" <pralnico@.discussions.microsoft.com> wrote in message
news:1C221973-1029-4380-8C24-A8C55817567F@.microsoft.com...
> Hello,
> Whats's the utility / advantages of the "Transactional publication with
> updatable subscriptions"
> thanks for your help!!!
>
Transactional replication starts with a snapshot. Thereafter only the
changes are replicated (which will typically mean less network traffic /
more frequent updates / less latency between different copies of the
database).
Updateable subscriptions means that the destination servers (subscribers)
can update the data on their own SQL Servers. SQL server will update it
locally and at the same time on the Publisher database, so that the changes
can then be replicated out to the other subscribers. This is done via a
distributed transaction.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.775 / Virus Database: 522 - Release Date: 08/10/2004
Saturday, February 25, 2012
Replication
Labels:
advantages,
database,
microsoft,
mysql,
oracle,
publication,
replication,
server,
sql,
subscriptions,
transactional,
utility,
whatss,
withupdatable
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment