Re: Transactional Replication

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 19:47:15 -0000

Kyle,
transactional replication and log shipping have both been used for this sort
of thing. Log shipping is usually the more appropriate, but have a look here
for a high-level comparison: http://www.replicationanswers.com/Standby.htm
 Rgds,
 Paul Ibison SQL Server MVP, www.replicationanswers.com
  (recommended sql server 2000 replication book:
  http://www.nwsu.com/0974973602p.html)

Relevant Pages

  • Re: Best way to keep a database clone syncd
    ... I figured that when we have a schema change, ... Does it matter that they would be different versions of SQL Server? ... There is a wizard in SQL to handle log shipping for you. ... Transactional replication applies changes as normal t-sql insert/update statements, but does not get all schema bblects. ...
    (microsoft.public.sqlserver.server)
  • Re: Replicating Multiple Databases
    ... Potential alternatives (not ... simpler) include log shipping and transactional replication. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • java replication app
    ... transfer data from sql server X to sql server Y (transactional replication ... I'm pretty new to this sort of thing, ... Java application be notified when a record is updated/inserted into X so ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Newbie Question
    ... For this scenario I'd investigate Log Shipping. ... (Database Mirroring and Transactional Replication) ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Reporting DB Question
    ... compared sql server 2000 transactional replication and log shipping: ...
    (microsoft.public.sqlserver.replication)