python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - transactional-replication

Why are read-only nodes called read-only in the case of data store replication?

I was going through the article, https://learn.microsoft.com/en-us/azure/architecture/patterns/cqrs which says, "If separate read and write databases are used, they must be kept in sync". On...
test-img

Arvind Kumar Avinash

serverless

cqrs

database-replication

sharding

transactional-replication

Votes: 0

Answers: 1

Latest Answer

All of these have "it depends"-like answers... Yes, usually, although some implementations might choose to (try to) update read models transactionally with the update. With multiple nodes ...
test-img

sellotape

SQL Data Replication - Get data into one table from multiple tables

I have 2 databases on different servers globaly. Both database has these 4 tables in it Orders : id, customerid, orderNumber Products: id, productCode Customer: id, customername Orderdetails: id, qua...
test-img

Sarah

sql-server

database-replication

transactional-replication

Votes: 0

Answers: 2

Latest Answer

Is there any recommended way of doing this preferably without triggers? Write a view that joins the tables together and produces the output you want. Then consider using this view to load a separat...
test-img

David Browne - Microsoft

SQL Server Transactional Replication - Can propagation of schema changes and data changes be controlled?

In transaction replication, if schema changes happen first and then the data changes, will it happen the same way in subscriber as well? If no, is there a way to control the order?
test-img

sagar pant

sql-server

replication

transactional-replication

Votes: 0

Answers: 1

Latest Answer

If schema changes happen first and then the data changes, will it happen the same way in subscriber as well? Yes - replication keeps track of what needs to be done via reading the transaction log an...
test-img

Ben Thul

Posts

Questions

Blogs

Jobs