SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Replication: SQL 2008 R2 Publisher to SQL 2012 Subscriber


Replication: SQL 2008 R2 Publisher to SQL 2012 Subscriber

Author
Message
DVSQL
DVSQL
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1885 Visits: 349
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.
JeremyE
JeremyE
SSCrazy Eights
SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)

Group: General Forum Members
Points: 9675 Visits: 4119
Yes, this is possible.

http://msdn.microsoft.com/en-us/library/ms143699.aspx
Stivan Widick
Stivan Widick
SSC-Enthusiastic
SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)

Group: General Forum Members
Points: 144 Visits: 36
The link that the responder answered with has nothing to do with the question that was asked.
JeremyE
JeremyE
SSCrazy Eights
SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)

Group: General Forum Members
Points: 9675 Visits: 4119
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.
Stivan Widick
Stivan Widick
SSC-Enthusiastic
SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)

Group: General Forum Members
Points: 144 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."
William Soranno
William Soranno
Right there with Babe
Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)

Group: General Forum Members
Points: 746 Visits: 522
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
happycat59
happycat59
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17695 Visits: 3294
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)



jns on the net
jns on the net
Valued Member
Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)

Group: General Forum Members
Points: 55 Visits: 107
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
William Soranno
William Soranno
Right there with Babe
Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)

Group: General Forum Members
Points: 746 Visits: 522
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
Jon.Morisi
Jon.Morisi
SSCertifiable
SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)

Group: General Forum Members
Points: 7534 Visits: 1143
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search