- Forum
- Main PGNP Forum
- SQL Server/DTS/SSIS/Linked servers/Replication
- SQL Server transactional replication
SQL Server transactional replication
1 month 4 days ago #14570
by tvlastnik
tvlastnik created the topic: SQL Server transactional replication
We are using SQL Server 2014 SP2 with transactional replication to Postgres 13. Every time there is a server restart or a connection is lost etc. a new snapshot is applied. We have tried version 3590 and 3612 with the same results.
How can it get it to not apply the snapshot every time their is a communication blip or when the SQL Server is restarted?
How can it get it to not apply the snapshot every time their is a communication blip or when the SQL Server is restarted?
Please Log in or Create an account to join the conversation.
4 weeks 2 days ago #14571
by admin
admin replied the topic: SQL Server transactional replication
Please try some previous builds of the PGNP provider (e.g. 3542, 3556) since it is known that the scenario worked with older build. We are working on locating the recent changes that resulted in this issue.
Please Log in or Create an account to join the conversation.
- Forum
- Main PGNP Forum
- SQL Server/DTS/SSIS/Linked servers/Replication
- SQL Server transactional replication
Time to create page: 0.071 seconds
- You are here:
-
Home
-
Forum
-
Main PGNP Forum
-
SQL Server/DTS/SSIS/Linked servers/Replication
- SQL Server transactional replication