Wednesday, March 7, 2012

Different Service Pack

Hello Group,
has anyone experinced problems with replication between SQL servers on
different service packs? I have a customer I am setting up a replication for
that has a SQL Server 2000 on SP4 and another on SP3. I want them to upgrade
the SP3 one but they are not going to do it because they are waiting on some
hardware. Once the hardware gets here, they are going to dump all the 2000
and go to 2005.
In the meantime, they do not want to change anything...just get a
replication going between these two servers. Should just do it? Have you
seen any problems with this?
rich
There are occasionally errors with MDAC incompatibilities. Also sometimes
the sp does not seem to apply completely.
RelevantNoise.com - dedicated to mining blogs for business intelligence.
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
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:D46C5011-5447-44A2-82EE-F19B402CFF2D@.microsoft.com...
> Hello Group,
> has anyone experinced problems with replication between SQL servers on
> different service packs? I have a customer I am setting up a replication
> for
> that has a SQL Server 2000 on SP4 and another on SP3. I want them to
> upgrade
> the SP3 one but they are not going to do it because they are waiting on
> some
> hardware. Once the hardware gets here, they are going to dump all the
> 2000
> and go to 2005.
> In the meantime, they do not want to change anything...just get a
> replication going between these two servers. Should just do it? Have you
> seen any problems with this?
> rich

No comments:

Post a Comment