what are the best ways to sync two databases in sql server or azure sql db?
You seem to want to do data replication in almost real-time. Why haven’t you considered SQL Server data replication or even better, an availability group?
Our data warehouse is setup as a cluster-less availability group and the TB sized DBs are kept in sync.