SQL2K sp3
Howdy all ...its been some time since Ive been around these parts.
I may need to start replicating to a denormalized DB. I tested this a while
back and it was grueling. After spinning my wheels for a couple of weeks my
then emplyer decided he wanted to keep the db as is so I just did normal
replication. Now if memory servers correctly, the only method I found for
successful replication to a denormalized db was to create Clustered Indexed
Views on the Publisher, and then replicate those, not the tables. I recall
trying another method (dont remember what it was), that was totally
unsuccessful. I need to do 1 way, continuous, Transactional replication. So
my questions are:
1; Are there other methods?
2; If so, what are they?
3; Are they in Hillary's book?
4; I may have the luxury of making the Subscriber SQL2K5, will that help
accomplish my goials.
TIA, ChrisR
Chris,
as an alternative to indexed views, you could use transformable
subscriptions, which is a mix of replication and DTS. This applies to SQL
Server 2000 rather than 2005 AFAIR.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment