0

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?

sagar pant
  • 377
  • 1
  • 2
  • 12

1 Answers1

1

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 and replaying those transactions in LSN order to subscribers. You shouldn't have to worry about out-of-order operations in general.

Ben Thul
  • 31,080
  • 4
  • 45
  • 68