Replication from SQL-Server 2014 (publisher) -> SQL Server for Linux 2019 Preview (subscriber)

%3CLINGO-SUB%20id%3D%22lingo-sub-265187%22%20slang%3D%22en-US%22%3EReplication%20from%20SQL-Server%202014%20(publisher)%20-%26gt%3B%20SQL%20Server%20for%20Linux%202019%20Preview%20(subscriber)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-265187%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20get%20a%20transactional%20pull%20replication%20subscription%20going%20from%20SQL-Server%202014%20(publisher)%20-%26gt%3B%20SQL%20Server%20for%20Linux%202019%20Preview%20(subscriber)%2C%20but%20running%20into%20some%20issues.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESSMS%20is%20giving%20an%20error%20when%20creating%20the%20distributor%2C%20which%20says%20that%20sql%20version%20in%20your%26nbsp%3B2019%20cant%20create%20distribution%20objects.%20We're%20also%20getting%20an%20error%20saying%20the%20subscriber%20version%20is%20higher%20than%20publisher%20so%20we%20cant%20not%20subscribe%202019%20to%26nbsp%3Bthe%202014%20server.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20all%20seems%20like%20it%20should%20be%20possible.%20Where%20can%20I%20go%20to%20ask%20questions%20for%20help%20on%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-265187%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EContainers%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQl-Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi all,

 

I'm trying to get a transactional pull replication subscription going from SQL-Server 2014 (publisher) -> SQL Server for Linux 2019 Preview (subscriber), but running into some issues. 

 

SSMS is giving an error when creating the distributor, which says that sql version in your 2019 cant create distribution objects. We're also getting an error saying the subscriber version is higher than publisher so we cant not subscribe 2019 to the 2014 server. 

 

This all seems like it should be possible. Where can I go to ask questions for help on this? 

 

Thanks.

0 Replies