After the tip https://www.mssqltips.com/sqlservertip/5526/how-to-setup-and-use-a-sql-server-stretch-database/ I made a video to show step by step how to enable stretch database.
The common way to replicate data and objects from one server to another is using transactional replication. As you know, SQL Server processes
In a post about how update works I showed what happened when run an update with the same values. SQL Server
When thinking about migration the most common issue is downtime. There are some methods that require downtime like backup/restore or