New answers tagged transactional-replication
1
vote
Accepted
logical replication initial phase
re 1)
No, you don't need to do anything. As soon as you create the subscription, Postgres will copy the data. You can prevent the initial copy if you wanted to, by using with (copy_data = false) when ...
0
votes
I am looking for a query to determine when the snapshot has been finished applying on the subscriber
select * from MSdistribution_history where comments like 'delivered snapshot%'
0
votes
SQL server replication conflicts
This is likely because the Articles that are used in both your Snapshot and
Transactional Publications have their Destination Object properties set to "Truncate all data in the existing object&...
Top 50 recent answers are included
Related Tags
transactional-replication × 484sql-server × 375
replication × 231
sql-server-2008-r2 × 71
sql-server-2012 × 60
sql-server-2014 × 51
sql-server-2016 × 48
availability-groups × 29
sql-server-2008 × 23
snapshot × 14
sql-server-2005 × 13
azure-sql-database × 13
transaction-log × 12
high-availability × 11
merge-replication × 11
postgresql × 10
migration × 10
sql-server-2017 × 9
mysql × 6
sql-server-agent × 6
sql-server-2019 × 6
clustering × 5
linked-server × 5
failover × 5
log-shipping × 5