SQL Server Performance

Transactional Rep.

Discussion in 'Performance Tuning for SQL Server Replication' started by bfarr23, Jul 16, 2003.

  1. bfarr23 New Member

    I have an OLTP data model that I want to be the publisher. The subscriber will be a de-normalized version of that data model. Thus two different schemas.
    I want to transactionally replicate from teh OLTP model to the de-normalized model.

    Is this possible?
    How is this accomplished?

    (sql server 2000)
  2. tkelley New Member

    I'm not really sure you will get that to work if the schemas are different. Here is an alternative to Transactional replication that is really more efficient that having the log reader process constantly running.

    Check this out:
    http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8759

    Good luck and post back if you get it to work.

    ----------
    T Kelley
    MS, MCDBA, OCA, CIW

Share This Page