August 13, 2003 at 5:58 am
I need to replicate from an OLTP database to a de-normalized version of the database. Two separate physical locations.
SQL Server 2000 Enterprise Edition.
Is this possible?
Options?
August 13, 2003 at 6:11 am
Location doesnt matter as long as you have connectivity and have access. I'd say your options are to replicate as is, then have triggers on the subscriber that handle the changes you need, or use DTS transforms as part of replication to do it as the data is replicated. Or some hybrid of the two.
Andy
September 4, 2003 at 8:36 am
You could also replace the MS replication Sps (eg sp_MSins_TOrder) with your own. See sp_addarticle, specifically @ins_cmd and @schema_option (needs to be 0x00000000000000E1 for this option I think.)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply