Transactional replication with transform from 2000 to 2005 -- sql server replication

Steve
1/19/2006 10:48:35 AM

I just had to add a 2005 subscription to a 2000 publication that
required a transform for the original 2000 subscribers ( table and
column names were different between publisher and subscriber).

When I tried to add the 2005 subscription in the 2000 publisher I got
an error in the wizard sayng I would have to set up a pull subscription
in 2005. When I used the wizard in 2005 it told me I had to push from
2000 since I also needed a transform.

I didn't find BOL to be usefull.

The solution was to register the 2005 server on the 2000 server by
taking the "register anyway" option when registration failed - It shows
up but you can't drill down to any objects in EM. Then you can set up
the subscription on the 2000 Publisher.

Since DTS is gone so there is no tranform available for the article so
I used the sp_changearticle stored procedure on the publisher to change
table and column names for the subscriber.

Michael Hotek
1/20/2006 3:45:44 AM

Transformable subscriptions was deprecated in 2005, because it relies on
DTS. The interfaces weren't upgraded into SSIS. You can still do this, but
you have to install DTS support on 2005.

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

[quoted text, click to view]

sql server replication : Transactional replication with transform from 2000 to 2005