Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication: SQL 2008 R2 Publisher to SQL 2012 Subscriber Expand / Collapse
Author
Message
Posted Friday, April 13, 2012 12:41 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 25, 2014 6:56 PM
Points: 75, Visits: 297
Just curious to see if this is something that's possible to do. I'd imagine that there should not be any problems, since you can do the same with 2005 to 2008, perhaps I've overlooked something? This will be for transactional replication.
Post #1283357
Posted Friday, April 13, 2012 2:09 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:30 PM
Points: 2,856, Visits: 3,041
Yes, this is possible.

http://msdn.microsoft.com/en-us/library/ms143699.aspx
Post #1283437
Posted Tuesday, May 8, 2012 2:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 8, 2012 3:29 PM
Points: 2, Visits: 36
The link that the responder answered with has nothing to do with the question that was asked.
Post #1296741
Posted Tuesday, May 8, 2012 2:13 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:30 PM
Points: 2,856, Visits: 3,041
Did you read anything from the link?

The 3rd bullet point in:

Subscriber version depends on the type of publication:

A Subscriber to a transactional publication can be any version within two versions of the Publisher version. For example: a SQL Server 2005 Publisher running can have SQL Server 2012 Subscribers; and a SQL Server 2012 Publisher can have SQL Server 2005 Subscribers.

Post #1296745
Posted Tuesday, May 8, 2012 2:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 8, 2012 3:29 PM
Points: 2, Visits: 36
Yes, sorry, I did miss that bit.

Might want to also include the following, as merge is an exception: "A Subscriber to a merge publication can be any version less than or equal to the Publisher version."
Post #1296760
Posted Thursday, February 21, 2013 1:48 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 14, 2014 12:51 PM
Points: 76, Visits: 423
I must be missing something. I have just finished rebuilding my publishing sql server on sql server 2008 r2. When I try to add one of my sql server 2012 servers as a subscriber I get the following error message:

The selected Subscriber does not satisfy the minimum version compatibility level of the selected publication.

The publisher is 2008 R2 SP2 and the subscriber is 2012 SP1.


Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143

"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
Post #1422437
Posted Thursday, February 21, 2013 8:53 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:03 PM
Points: 2,967, Visits: 2,569
I am not sure but I suspect that the distributor you are using is SQL 2008 R2. Normally, I would expect the distributor to be the most recent version of all of the SQL servers involved (in your case, this would mean that your distributor should be SQL 2012)


Post #1422857
Posted Monday, February 25, 2013 5:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 11, 2014 3:27 AM
Points: 3, Visits: 106
There are some issues if you connect to SS2012 (Subscriber) with SQL Management Studio 2008 or 2008 R2 (Publisher/Distributor).
Try with stored procedure or with SQLCMD

DECLARE @publication AS sysname;
DECLARE @subscriber AS sysname;
DECLARE @subscriptionDB AS sysname;
DECLARE @frequency_type as int;
DECLARE @subscriber_security_mode as int;
DECLARE @subscriber_login AS sysname;
DECLARE @subscriber_password AS sysname;

SET @publication = ______________ ;
SET @subscriber = ________________;
SET @subscriptionDB = _______________;
SET @frequency_type= ___ ; --(you must check frequency type)
SET @subscriber_security_mode= ___ ; --(you must check security mode)
SET @subscriber_login=______________;
SET @subscriber_password=__________; --(if security mode is 0, SQL Server authentication)

--Add a push subscription to a transactional publication.
USE [DBName]

EXEC sp_addsubscription
@publication = @publication,
@subscriber = @subscriber,
@destination_db = @subscriptionDB,
@subscription_type = N'push';

EXEC sp_addpushsubscription_agent
@publication = @publication,
@subscriber = @subscriber,
@subscriber_db = @subscriptionDB,
@subscriber_security_mode=@subscriber_security_mode,
@subscriber_login=@subscriber_login,
@subscriber_password=@subscriber_password,
@frequency_type = @frequency_type,
@job_login = ___________,
@job_password = __________;
GO
Post #1423558
Posted Monday, February 25, 2013 7:10 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 14, 2014 12:51 PM
Points: 76, Visits: 423
Using the sql script worked.
Thanks


Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143

"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
Post #1423604
Posted Wednesday, May 21, 2014 8:37 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 10, 2014 4:15 AM
Points: 293, Visits: 816
Apparently if you just use SSMS from the subscriber (SQL 2012) side, you won't get the error:

http://www.keepitsimpleandfast.com/2013/07/the-selected-subscriber-does-not.html
Post #1573214
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse