sql server replication: Applying of snapshot for transaction replication with DTS transfor -- sql server replication

Applying of snapshot for transaction replication with DTS transfor

andsm
12/27/2005 1:20:21 PM

sql server replication:

I created transaction replication with DTS transformation. Next I want to
move all data from publisher to subscriber - apply snapshot to subscriber.
Subscriber have different schema but no data. How it is possible to do? I
expected snapshot will use same DTS, but it not use it. Publisher DB is 24/7

Re: Applying of snapshot for transaction replication with DTS transfor

Hilary Cotter
12/27/2005 10:12:36 PM

Have a look at transformable subscriptions. I would also advise you to have
a look at custom sync objects and encapsulating the data mapping in the
replication stored procedures as opposed to use DTS transforms due to
performance reasons.

Here is an article explaining how to do this.

http://www.dbazine.com/sql/sql-articles/cotter1/view?searchterm=replicating

--
Hilary Cotter
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

[quoted text, click to view]