August 21, 2024 at 3:20 pm
Does anyone know where I can find actual documentation on how to setup bidirectional transactional replication? All I can find on MS is that you create a publisher and subscriber on both sides; but when I do this, I keep getting errors on both ends that it cannot truncate (or recreate) the tables on the other end because they're published for replication.
Also - the eventual goal is to replicate a database between a local SQL Server instance and an Azure Managed SQL Instance - has anyone done this and if so could you share your experience setting up?
I'm fairly familiar with transactional replication - I've set it up numerous times - but this is my first attempt at making it bidirectional, and the documentation is pretty sparse.
August 22, 2024 at 4:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
August 22, 2024 at 7:42 pm
So I've figured out that what I really need to use is Merge Replication - which I was able to setup pretty easily between two local servers.
The problem I'm running into now is that when I try to set it up between our local server and Azure Managed SQL, it seems to setup ok and even creates the tables on the remote side; but when it tries to push actual data it throws an error saying:
Could not find stored procedure 'sp_MSsetcontext_replagent'. (Source: MSSQLServer, Error number: 2812)
Sure enough, when I log into the remote instance, I cannot find that procedure. Not sure if the setup failed and just didn't throw an error, or if there are different/additional steps we need since it's a managed sql instance.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply