Making a subscriber the publisher

SQL 2000 /Windows 2000 Server
I need to shut the publisher down and remove it from the
network. Then I need the subscriber to now become the
publisher and push to other subscribers.
Is this as easy as just removing Data Replication, and
then recreating it, making the old subscriber, the
publisher?
Thx,
Don
Possibly. It depends on what type of replication you are doing. If you are
using merge it should just work after you have dropped the subscription.
With transactional that depends on if you are replicating DRI which will
replicate the primary keys as primary keys to the subscriber. If you were
not replicating DRI the primary keys will be replicated as unique indexes on
the subscriber and you will have to convert them to primary keys before your
can publish these tables.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Don" <anonymous@.discussions.microsoft.com> wrote in message
news:0fa001c48bba$5e3e36d0$a301280a@.phx.gbl...
> SQL 2000 /Windows 2000 Server
> I need to shut the publisher down and remove it from the
> network. Then I need the subscriber to now become the
> publisher and push to other subscribers.
> Is this as easy as just removing Data Replication, and
> then recreating it, making the old subscriber, the
> publisher?
> Thx,
> Don
>