Migration ideas of On-prem 2019 sql server trascational replication to azure or fabric.

[Jothi Lakshmi P M]

Hello, I need to bring data from multiple sql servers of 2019 version into either azure or fabric environment without and intermediate storage(if possible). Currently we are using sql transaction replication but need to migrate from this. Which are the possible ways ro achieve it, i need to have real time data availability without using cdc or event triggers because this can affect the business. Help me with all possible ways.

Continue reading...