SQL Server Performance Forum – Threads Archive
Transactional Rep.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)
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. ———-
MS, MCDBA, OCA, CIW