Re: SQL 2000 <-> SQL 2005

I would use bi-directional transactional replication for this as the latency
can be as low as seconds. Merge can be used but it requires schema changes
(adding of a GUID column), slows down each transaction (i.e. all inserts,
updated and deletes) are slower, and the latency is typically in the order
of minutes.

--
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



"Terry Mulvany" <terry.mulvany@xxxxxxxxxxxxxxxxx> wrote in message
news:%23YhJ03YOHHA.4260@xxxxxxxxxxxxxxxxxxxxxxx
Group,
I have a situation where I need to sync data over a VPN (T-1 connectivity)
on a semi-realtime basis. This data is not highly dynamic, at most a few
thousand rows change per day.

I have SQL 2000 on one end and SQL 2005 on the other. Can 2000 and 2005
work together?

What is the best replication type for close to real time synchronization,
is it 'Merge'?

Can syncs be manually initialized in the prescribed type?

Thank you.



.

Relevant Pages

  • Re: a different identiy columns in replication question
    ... Ive done a bit of schema changes on replicated tables in the past. ... queued benifit the cause? ... > queued and bi-directional transactional replication are options. ...
    (microsoft.public.sqlserver.replication)
  • Re: Missing ForestDNSZones and DomainDNSZones partitions under child AD 2003 domain
    ... REPLICATION LATENCY WARNING ... Replication of new changes along this path will be delayed. ... Latency information for 3 entries in the vector were ... had no latency information (Win2K DC). ...
    (microsoft.public.windows.server.dns)
  • Re: dcdiag - replication Concerns
    ... REPLICATION-RECEIVED LATENCY WARNING ... Last replication recieved from SERVER2 at 2009-03-30 ...
    (microsoft.public.windows.server.active_directory)
  • Re: dcdiag - replication Concerns
    ... As said before 2 ways to fix the tombstone lifetime problem, ... from above about getting replication back to work or remove the DC. ... REPLICATION-RECEIVED LATENCY WARNING ... WARNING: This latency is over the Tombstone Lifetime ...
    (microsoft.public.windows.server.active_directory)
  • Re: Major Latency problems
    ... replication monitor is because they are occasionally wrong. ... represent cumulative values since the last time the distribution agent ... Replication monitor latency is 1 ... you're asking me to alter a stock replication system table. ...
    (microsoft.public.sqlserver.replication)
Loading