1. Forum
  3. Main PGNP Forum
  5. SQL Server/DTS/SSIS/Linked servers/Replication
  7. SQL Server transactional replication

SQL Server transactional replication

More
1 year 4 months ago #14570 by tvlastnik
SQL Server transactional replication was created by tvlastnik
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?

Please Log in or Create an account to join the conversation.

More
1 year 4 months ago #14571 by admin
Replied by admin on 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.

  1. Forum
  3. Main PGNP Forum
  5. SQL Server/DTS/SSIS/Linked servers/Replication
  7. SQL Server transactional replication
Time to create page: 0.051 seconds
Powered by Kunena Forum