Re: transformable subscriptions between SQL Server 2000 and 2005

From: "Michael Hotek" <mike@xxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 13 Feb 2006 07:19:16 -0600

Might have been designed for, but isn't how it is used in at least 1/2 of
the implementations that I've seen.

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:ue4JyO0LGHA.420@xxxxxxxxxxxxxxxxxxxxxxx

Transformable subscriptions were designed to massage the data from one
form to another FOR HETERGENEOUS SUBSCRIBERS. For SQL Server subscribers
you would incorporate the massaging logic inside your custom replication
stored procedure.

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

"Mike Mullane" <MikeMullane@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B8819D13-5DE2-4C15-AB9B-6144F15C28AF@xxxxxxxxxxxxxxxx

I see that transformable subscriptions have been deprecated in SQL Server
2005. And although SQL Server BOL tells you how to setup SSIS to run DTS
packages it also notes that this will be discontinued in future
releases...
What is my alternative to transformable subscriptions in SQL Server 2005
and
not having to setup DTS backward compatibility?

I want to publish from SQL Server 2000 and SQL Server 2005 will subscribe
to
this publication. However the data needs to transformed. Any suggestions?

Thanks. Mike

References:
- Re: transformable subscriptions between SQL Server 2000 and 2005
  - From: Hilary Cotter

Prev by Date: Re: Advice Needed: Asynchronous Replication/Mirroring to central o
Next by Date: Re: transformable subscriptions between SQL Server 2000 and 2005
Previous by thread: Re: transformable subscriptions between SQL Server 2000 and 2005
Next by thread: Re: transformable subscriptions between SQL Server 2000 and 2005
Index(es):
- Date
- Thread

Relevant Pages

Re: Can merge replication be used to keep two database in sync
... the number of subscribers before it started slowing down. ... If you are going to post numbers, particularly with the replication engine, ... in SQL Server 6.5, I've had implementations in production that have ALWAYS ... Broken down by transaction per minute ...
(microsoft.public.sqlserver.replication)
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: Is restore of a republishing database possible from one of its subscribers in merge replication?
... Looking for a SQL Server replication book? ... I've a republishing database which has more ... I've all the data on its subscribers. ...
(microsoft.public.sqlserver.replication)
Re: URGENT!! Reducing subscription expiration questions
... The Merge Agent failed after detecting that retention-based metadata ... The subscribers have SQL Server 2005 Workgroup ... We believe that the no expiration setting is causing these ...
(microsoft.public.sqlserver.replication)
Re: URGENT!! Reducing subscription expiration questions
... Looking for a SQL Server replication book? ... subscribers are dropping out of scope and then get really proactive about ... Can we reinitialize one subscriber at a time after changing the retention? ... We believe that the no expiration setting is causing these ...
(microsoft.public.sqlserver.replication)