Groups | Blog | Home
all groups > sql server replication > august 2003 >

sql server replication : real time sincronization


Brenda
8/14/2003 5:22:45 PM
Hello,

I am just started in this, but I am interested in what in spanish is called
"duplicacion de instantaneas", I dont know the proper trasnlation to english
so I will try t explain it. This allows to sincronized a pasive database on
the server with the active database on the client who is running the
application trough TCP/IP and there are some things I want to know
1) What are the server requirements to do this (ram, bandwidth. etc) to be
able to check the client data in the server in real time.
2) Is this schema possible if the server is running sql server 200 and the
client MSDE? If so, which are mi limitations?
3) Is the client performance damage with the sincronization? If so, are somo
percentages of this?

Thanks

Brenda




Paul Ibison
8/15/2003 2:03:52 AM
Brenda,
for real-time synchronisation, this is not possible using
replication. For this you need distributed transactions
and linked servers, which works with all versions of SQL
Server. If you are prepared to have a degree of latency,
then transactional or merge (one-way) could be used to
prepare a reporting server. If the subscriber needs to
update the data, then both of these methods can also be
used (but differently configured). As for bandwidth
issues, I have no definitive figures as this depends on a
lot of variables - the amount of data modifications, other
network traffic etc. For my own part, I have latency down
to a few seconds (4ish) using merge replication.
HTH
Hilary Cotter
8/15/2003 8:52:10 AM
Hola!

In English this is termed transactional or snapshot
replication with immediately updating subscribers.

1) there are no real hardware requirements, but you must
have MS DTC running on both servers. You MUST have a very
well connected connection otherwise updates at the
subscribers will fail after hanging for 20 or more
seconds. You will get a server access denied error
message.

2) yes

3) Performance will be degraded slightly more than pure
transactional replication but less than merge replication.

The real problem with immediately updating subscribers is
that all transactions will be applied on the publihsher as
singletons which mean one row at a time.

So if you have subscribers where a lot of data is been
updated you might find your performance and latency to be
worse than with pure transactional.
[quoted text, click to view]
Brenda
8/19/2003 2:03:17 PM
Thanks

"Hilary Cotter" <hilaryK@att.net> escribió en el mensaje
news:0c1a01c36345$2fc5a0c0$a401280a@phx.gbl...
[quoted text, click to view]

AddThis Social Bookmark Button