Replicating from SQL 2000 to SQL 2008
in [Replication]
|
From: Jay Konigsberg on 21 Mar 2010 12:40 Two things. 1) Make sure your 2000 instance is SP3. 2) The distributor can't be a higher version than the publisher, in this case 2000 SP3. Using Multiple Versions of SQL Server in a Replication Topology http://msdn.microsoft.com/en-us/library/ms143241.aspx 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:51 Two things. 1) Make sure your 2000 instance is SP3. 2) The distributor can't be a higher version than the publisher, in this case 2000 SP3. Using Multiple Versions of SQL Server in a Replication Topology http://msdn.microsoft.com/en-us/library/ms143241.aspx 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
From: Jay Konigsberg on 21 Mar 2010 12:54 Two things. 1) Make sure your 2000 instance is SP3. 2) The distributor can't be a higher version than the publisher, in this case 2000 SP3. Search BOL for: "Using Multiple Versions of SQL Server in a Replication Topology" 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 ..
From: Jay Konigsberg on 21 Mar 2010 13:01 Two things. 1) Make sure your 2000 instance is SP3. 2) The distributor can't be a higher version than the publisher, in this case 2000 SP3.
From: Jay Konigsberg on 21 Mar 2010 13:17 OK Sorry guys, I was replying from the SQL Server group and none of the replies were showing up. It was driving me nuts and I was determined to figure it out. Somehow, the server wasn't dealing with the multiple groups correctly and showing the replies in all the groups (specifically microsoft.public.sqlserver.sqlserver). -- 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.
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 Prev: Script or command to reinitialize a publication Next: Basic replication question |