September 22, 2009 at 1:04 pm
We are in the initial stages of designing a transactional replication architecture where the publishing SQL Server is a 2005 machine and desire the distributor and subscriber SQL Servers to be running 2008.
I have setup SQL Server 2000 publishers using SQL Server 2000 distributors and SQL Server 2005 Publishers using SQL Server 2005 distributors but wanted to make sure. I have also seen this:
http://msdn.microsoft.com/en-us/library/ms143241.aspx
That talks about it a little:
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:
* sp_MSchange_snapshot_agent_properties (Transact-SQL)
* sp_MSchange_logreader_agent_properties (Transact-SQL)
* sp_MSchange_distribution_agent_properties (Transact-SQL)
* sp_MSchange_merge_agent_properties (Transact-SQL)
If you have a Publisher and Distributor that are running SQL Server 2000, you can change the credentials under which agents make connections by using sp_changedistpublisher and sp_changesubscriber. However, if you upgrade the Distributor to SQL Server 2008, these procedures cannot be used to change the credentials that are used in existing agent jobs. The procedures do affect agent jobs that are created after the procedure is called. To change the credentials for existing agent jobs, call one of the four procedures listed previously.[/i]
Any help would be appreciated in this area.
Thanks,
Anthony
September 22, 2009 at 1:54 pm
I have a friend of a friend at Microsoft who said this can be done without a problem.
Thanks,
Anthony
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply