Tuesday, March 20, 2012

Replication and MSDE Upgrade

I have a merge replication set up with a SQL 2000 publisher and an MSDE
subscriber. We are at a point where we are considering upgrading the MSDE
install to SQL 2000. I know the install/upgrade process is relatively simple.
Are there any precautions or issues with replication in upgrading from MSDE
to full SQL.
Thank you,
JH
No there are none, I take it that you are using push subscriptions correct?
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
"halej51" <halej51@.discussions.microsoft.com> wrote in message
news:B964744D-12EE-4E37-A565-D8C9EC26BA06@.microsoft.com...
> I have a merge replication set up with a SQL 2000 publisher and an MSDE
> subscriber. We are at a point where we are considering upgrading the MSDE
> install to SQL 2000. I know the install/upgrade process is relatively
simple.
> Are there any precautions or issues with replication in upgrading from
MSDE
> to full SQL.
> Thank you,
> JH
>
|||Yes,
The replica/snapshot resides on the publisher.
Thank you for the answer.
"Hilary Cotter" wrote:

> No there are none, I take it that you are using push subscriptions correct?
> --
> 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
> "halej51" <halej51@.discussions.microsoft.com> wrote in message
> news:B964744D-12EE-4E37-A565-D8C9EC26BA06@.microsoft.com...
> simple.
> MSDE
>
>

No comments:

Post a Comment