SQL DB Migration

OnPremises to Azure:

1. Using Transactional Replication  - 
   
1. Points to consider
1. It requires short downtime.
2. Only push subscriptions to Azure are supported
3. Bi-directional, immediate, updatable, or peer to peer replication are not supported by Azure SQL Database
   
2. Steps
1. Set up Distributor and Publisher from OnPremises /
   
2. OnPremises, Replication > Local Publications > New Subscriptions - Configure azure DB
3. Monitor will be from OnPremises
   
3. Reference: By Prashanth Jayaram /

OnPremises to OnPremises