Re: Transformable v. regular subscriptions

Transformable Subscriptions use a DTS package to transform the data as it
moves from the Publisher to the Subscriber. It is intended to transform the
data when it goes to heterogeneous subscribers. It has been deprecated in
SQL 2005. If you need to transform the data for SQL Server subscribers you
are better to use custom stored procedures.

To answer your question, I take it that you are able to use the DTS package
code outside of the publication and it does not lose data. If so, you should
not be loosing data while using transformable subscriptions. You can always
log to a table where the DTS package runs for debugging purposes.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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



"Oskar" <Oskar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9839B177-4F0D-4C95-9E92-310B9288EE5C@xxxxxxxxxxxxxxxx
Forgot to mention that the data in the publication database for the
transactional replication is stored using a legacy multilingual DOS
codepage,
which is mapped to a single codepage that can be recognized by the SQL
Server
software on the servers.


"Oskar" wrote:

Hi,
Tell me please, is there any chance to lose or get altered data in a
susbcription database if the character mode format of snapshots and
transformable subscriptions are used in the transactional replication
that
was set up between MS SQL Server 2000 SP3 servers?

--Many thanks, Oskar



.

Relevant Pages

  • Re: transformable subscriptions between SQL Server 2000 and 2005
    ... Unfortunately, there isn't a replacement. ... And although SQL Server BOL tells you how to setup SSIS to run DTS ... What is my alternative to transformable subscriptions in SQL Server 2005 ... not having to setup DTS backward compatibility? ...
    (microsoft.public.sqlserver.replication)
  • Re: transformable subscriptions between SQL Server 2000 and 2005
    ... Transformable subscriptions were designed to massage the data from one form ... would incorporate the massaging logic inside your custom replication stored ... Looking for a SQL Server replication book? ... not having to setup DTS backward compatibility? ...
    (microsoft.public.sqlserver.replication)
  • Dynamic Filtering How??
    ... this only applies to merge replication. ... transformable subscriptions and separate DTS pachages per ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: transformable subscriptions between SQL Server 2000 and 2005
    ... form to another FOR HETERGENEOUS SUBSCRIBERS. ... Looking for a SQL Server replication book? ... What is my alternative to transformable subscriptions in SQL Server 2005 ... not having to setup DTS backward compatibility? ...
    (microsoft.public.sqlserver.replication)
Loading