"dk" <dk@discussions.microsoft.com> wrote in message
news:B96189E7-9630-4367-81AD-3F09957BDA2C@microsoft.com...
> Thanks Hilary for your responce. I did plan to buy your book, but thought
> if
> 2005 replication will be out soon, than I'd like toa have that one.
> So as far as I understand from your explanation, it's both Integration
> services (rpc) and linked server that play the roll. I heard that Sql2000
> and
> sql2005 have quite a bit of difference in the linked server approach.
> Would
> you know how much of that is correct? Thanks again.
> Best regards
> Dk
>
> "Hilary Cotter" wrote:
>
>> You can try my book in my sig.
>>
>> The technologies are snapshot, transactional, and merge replication. They
>> use rpc and ftp, and rely on executables to read and write to and from
>> SQL
>> Server.
>>
>> Transactional replication reads the transaction log and writes the
>> commands
>> it finds there which are marked for replication to the distribution
>> database
>> which is read by a distribution agent which uses sql statements or stored
>> procedures to write these commands to the subscriber db.
>>
>> There is a linked server involved between the publisher and subscriber.
>>
>> --
>> RelevantNoise.com - dedicated to mining blogs for business intelligence.
>>
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>>
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>> "dk" <dk@discussions.microsoft.com> wrote in message
>> news:696F75FA-E630-4365-BCD7-C8519A101654@microsoft.com...
>> > In the Books online it says : Replication is a set of technologies that
>> > allows you to keep copies of the same data on multiple sites...
>> > Could someone give me an answer on what is the 'set of technology' that
>> > keeps the transactional replication running. Does it use DTS packages
>> > (or
>> > Integrated services for 2005) or linked server at all or no. Also if
>> > there
>> > is
>> > a good book that can explain these details, please give me some
>> > recomendation.
>> >
>> > Thanks a lot
>> > Dk
>>
>>
>>