My requirement is that after every few days i need to migrate my on-premises SQL Server Database to Azure SQL Database. On-premises database will be updated in every few days.
What are the mostly used and cost effective options which are used when migrating on-premises SQL Server database to Azure SQL Database?
Based on above requirement which options shall I use to make sure once full backup of on-premises database is migrated to Azure SQL Database, incremental backups are migrated/merged correctly to already existing Azure SQL Database?
Can Azure Database migration service be used for #2, is it possible to automate this service so that it runs after specific time interval and migrates/merges the on-premises database correctly to Azure SQL Database? If this service could not be used for this operation, could you please suggest some other option?
It will be really helpful if you provide links/ example for this.