Replicating from SQL 2000 to SQL 2008 [Replication]

Prev: Script or command to reinitialize a publication
Next: Basic replication question

From: Query Builder on 20 Mar 2010 23:35

I have 2 instance of SQL Servers.

Instance A : SQL Server 2000 Enterprise Edition running on Windows
2003 (32 Bit).
Instance B : SQL Server 2008 Enterprise Edition running on Windows
2008 (64 Bit Cluster).
These servers both reside on different domains but have connectivity
between them using SQL Authentication.

I need to setup Transactional Replication from Server A to Server B.

I have reviewed the following MS KB: http://msdn.microsoft.com/en-us/library/ms143241.aspx

It States : "Using a SQL Server 2005 or SQL Server 2008 Distributor
with a Publisher Running SQL Server 2000
SQL Server 2005 and SQL Server 2008 can be used as a remote
Distributor for Publishers that are running SQL Server 2000. To change
agent properties in this scenario, execute the following stored
procedures at the Distributor. These procedures let you change
properties that were introduced in SQL Server 2005:"

I have tried executing the procedures but still am not able to make a
connection to the Publisher from The Subscriber.

Has anyone successfully implemented a SQL 2000 to SQL 2008
Transactional Replication? If so, can you please advise the steps you
had performed in order to set it up?

Thanks In advance..

Aravin Rajendra.

From: Jay Konigsberg on 21 Mar 2010 01:57

I did a little digging for you and found a relevent page.

Using Multiple Versions of SQL Server in a Replication Topology
http://msdn.microsoft.com/en-us/library/ms143241.aspx

"SQL Server 2000 and SQL Server 2005 can both participate in replication
topologies with SQL Server 2008. For SQL Server 2000 the minimum version is
Service Pack 3 (SP3). For SQL Server 2005 the minimum version is Service
Pack 2 (SP2)."

also

"For all types of replication, the Distributor version must be no earlier
than the Publisher version. (Frequently, the Distributor is the same
instance as the Publisher.)"

Which means that you can't use a 2008 instance as a distributor for your
2000 publisher, it must be 2000.

Good luck.

--
Jay Konigsberg
SQL Server DBA in Sacramento, CA
http://www.linkedin.com/in/jaykonigsberg

Live in Sacramento, CA?
Join the Sacramento SQL Server User Group on LinkedIn
http://www.linkedin.com/groups?home=&gid=2825448&trk=anet_ug_hm&goback=%2Emyg

"Query Builder" <querybuilder(a)gmail.com> wrote in message
news:f6880418-df19-49cc-93e1-aa9f5cb193de(a)g28g2000yqh.googlegroups.com...
>I have 2 instance of SQL Servers.
>
> Instance A : SQL Server 2000 Enterprise Edition running on Windows
> 2003 (32 Bit).
> Instance B : SQL Server 2008 Enterprise Edition running on Windows
> 2008 (64 Bit Cluster).
> These servers both reside on different domains but have connectivity
> between them using SQL Authentication.
>
> I need to setup Transactional Replication from Server A to Server B.
>
> I have reviewed the following MS KB:
> http://msdn.microsoft.com/en-us/library/ms143241.aspx
>
> It States : "Using a SQL Server 2005 or SQL Server 2008 Distributor
> with a Publisher Running SQL Server 2000
> SQL Server 2005 and SQL Server 2008 can be used as a remote
> Distributor for Publishers that are running SQL Server 2000. To change
> agent properties in this scenario, execute the following stored
> procedures at the Distributor. These procedures let you change
> properties that were introduced in SQL Server 2005:"
>
> I have tried executing the procedures but still am not able to make a
> connection to the Publisher from The Subscriber.
>
> Has anyone successfully implemented a SQL 2000 to SQL 2008
> Transactional Replication? If so, can you please advise the steps you
> had performed in order to set it up?
>
> Thanks In advance..
>
> Aravin Rajendra.

From: Jay Konigsberg on 21 Mar 2010 12:07

I did a little digging for you and found a relevant page.

Using Multiple Versions of SQL Server in a Replication Topology
http://msdn.microsoft.com/en-us/library/ms143241.aspx

"SQL Server 2000 and SQL Server 2005 can both participate in replication
topologies with SQL Server 2008. For SQL Server 2000 the minimum version is
Service Pack 3 (SP3). For SQL Server 2005 the minimum version is Service
Pack 2 (SP2)."

also

"For all types of replication, the Distributor version must be no earlier
than the Publisher version. (Frequently, the Distributor is the same
instance as the Publisher.)"

Which means that you can't use a 2008 instance as a distributor for your
2000 publisher, it must be 2000.

Good luck.

--
Jay Konigsberg
SQL Server DBA in Sacramento, CA
http://www.linkedin.com/in/jaykonigsberg

Live in Sacramento, CA?
Join the Sacramento SQL Server User Group on LinkedIn
http://www.linkedin.com/groups?home=&gid=2825448&trk=anet_ug_hm&goback=%2Emyg

"Query Builder" <querybuilder(a)gmail.com> wrote in message
news:f6880418-df19-49cc-93e1-aa9f5cb193de(a)g28g2000yqh.googlegroups.com...
>I have 2 instance of SQL Servers.
>
> Instance A : SQL Server 2000 Enterprise Edition running on Windows
> 2003 (32 Bit).
> Instance B : SQL Server 2008 Enterprise Edition running on Windows
> 2008 (64 Bit Cluster).
> These servers both reside on different domains but have connectivity
> between them using SQL Authentication.
>
> I need to setup Transactional Replication from Server A to Server B.
>
> I have reviewed the following MS KB:
> http://msdn.microsoft.com/en-us/library/ms143241.aspx
>
> It States : "Using a SQL Server 2005 or SQL Server 2008 Distributor
> with a Publisher Running SQL Server 2000
> SQL Server 2005 and SQL Server 2008 can be used as a remote
> Distributor for Publishers that are running SQL Server 2000. To change
> agent properties in this scenario, execute the following stored
> procedures at the Distributor. These procedures let you change
> properties that were introduced in SQL Server 2005:"
>
> I have tried executing the procedures but still am not able to make a
> connection to the Publisher from The Subscriber.
>
> Has anyone successfully implemented a SQL 2000 to SQL 2008
> Transactional Replication? If so, can you please advise the steps you
> had performed in order to set it up?
>
> Thanks In advance..
>
> Aravin Rajendra.

From: Jay Konigsberg on 21 Mar 2010 12:17

Here is the relevant man page.

Using Multiple Versions of SQL Server in a Replication Topology
http://msdn.microsoft.com/en-us/library/ms143241.aspx

"SQL Server 2000 and SQL Server 2005 can both participate in replication
topologies with SQL Server 2008. For SQL Server 2000 the minimum version is
Service Pack 3 (SP3). For SQL Server 2005 the minimum version is Service
Pack 2 (SP2)."

also

"For all types of replication, the Distributor version must be no earlier
than the Publisher version. (Frequently, the Distributor is the same
instance as the Publisher.)"

Which means that you can't use a 2008 instance as a distributor for your
2000 publisher, it must be 2000.

Good luck.

--
Jay Konigsberg
SQL Server DBA in Sacramento, CA
http://www.linkedin.com/in/jaykonigsberg

Live in Sacramento, CA?
Join the Sacramento SQL Server User Group on LinkedIn
http://www.linkedin.com/groups?home=&gid=2825448&trk=anet_ug_hm&goback=%2Emyg

"Query Builder" <querybuilder(a)gmail.com> wrote in message
news:f6880418-df19-49cc-93e1-aa9f5cb193de(a)g28g2000yqh.googlegroups.com...
>I have 2 instance of SQL Servers.
>
> Instance A : SQL Server 2000 Enterprise Edition running on Windows
> 2003 (32 Bit).
> Instance B : SQL Server 2008 Enterprise Edition running on Windows
> 2008 (64 Bit Cluster).
> These servers both reside on different domains but have connectivity
> between them using SQL Authentication.
>
> I need to setup Transactional Replication from Server A to Server B.
>
> I have reviewed the following MS KB:
> http://msdn.microsoft.com/en-us/library/ms143241.aspx
>
> It States : "Using a SQL Server 2005 or SQL Server 2008 Distributor
> with a Publisher Running SQL Server 2000
> SQL Server 2005 and SQL Server 2008 can be used as a remote
> Distributor for Publishers that are running SQL Server 2000. To change
> agent properties in this scenario, execute the following stored
> procedures at the Distributor. These procedures let you change
> properties that were introduced in SQL Server 2005:"
>
> I have tried executing the procedures but still am not able to make a
> connection to the Publisher from The Subscriber.
>
> Has anyone successfully implemented a SQL 2000 to SQL 2008
> Transactional Replication? If so, can you please advise the steps you
> had performed in order to set it up?
>
> Thanks In advance..
>
> Aravin Rajendra.

From: Jay Konigsberg on 21 Mar 2010 12:21

| Next | Last
Pages: 1 2 3
Prev: Script or command to reinitialize a publication
Next: Basic replication question