Question about Televison & Video
I want to do replication between sql server 2000 and sql server 2005 developer edition. if yes devloper edition can also perfrom replication then what hardware and software requirements are required for this.I have sql server 2005 n sql server 2000. i want one wy transaction from server 2000 to server 2005..how to move ahead with this? plz help.
waiting for ur reply,
SQL Server 2005 provides a lot of benefits over SQL Server 2000 including within the replication feature set.
You might be relieved to know that, although most of the benefits accrue on the side of a SQL Server 2005 Publisher, you can still set up SQL Server 2005 as a subscriber on a SQL Server 2000 Publisher. Thus, you can begin to merge in the newest release of SQL Server into an existing replication scheme. You can read more about this at http://msdn2.microsoft.com/en-us/library/ms217330.
Although major advantage to SQL Server 2005 over 2000 is that changes to the schema, such as through ALTER TABLE statements, replicate out to all subscribing servers. The cool news in a mixed version environment is that the ALTER TABLE statements will be published to SQL Server 2000 Subscribers from a SQL Server 2005 Publisher.
Posted on Jan 30, 2009
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Dec 11, 2014 | Microsoft Computers & Internet
Nov 06, 2014 | Microsoft SQL Server 2005 Standard Edition
Jan 28, 2011 | Microsoft SQL Server 2000 Standard Edition...
Jan 10, 2010 | Computers & Internet
Oct 28, 2009 | Microsoft SQL Server® 2005 Developer...
Feb 28, 2009 | Microsoft Visual Studio 2005 Professional...
Sep 24, 2007 | Microsoft SQL Server Standard Edition for...
Aug 30, 2007 | Microsoft SQL Server 2000 Standard Edition...
263 people viewed this question
Usually answered in minutes!