Transactional Replication betwn 2 SQL 2000 Srvs w/ diff servicepac

microsoft.public.sqlserver.server

13 May 2005 4:36 PM

Doug F.

I have a Production SQL 2000 server that is SQL 2000 SP2. We have another
server that is a DEV server that is running SQL 2000 SP3a. I need to set up
either transactional replication between the Production server (SP2) and the
DEV server (SP3a).

Does anyone know if this presents a problem, transferring data from servers
with different service pack levels?

Thanks.
Doug F.

13 May 2005 5:45 PM

JRStern

On Fri, 13 May 2005 09:36:08 -0700, "Doug F."
<Do***@discussions.microsoft.com> wrote:

>I have a Production SQL 2000 server that is SQL 2000 SP2. We have another
>server that is a DEV server that is running SQL 2000 SP3a. I need to set up
>either transactional replication between the Production server (SP2) and the
>DEV server (SP3a).
>
>Does anyone know if this presents a problem, transferring data from servers
>with different service pack levels?

Should be OK, I think.

You might ask on the microsoft.public.sqlserver.replication group!

Josh