Azure SQL Database
An Azure relational database service.
5,123 questions
You can use Data Sync to sync your On Prem Database to Azure SQL database
Migrating onpremises SQL Server Database to Azure SQL Database
salilsingh-9961
346
Reputation points
Hi Team,
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.
Thanks,
Salil
1 answer
Sort by: Most helpful
-
Nandan Hegde 29,886 Reputation points MVP2021-03-25T03:22:40.623+00:00 -
salilsingh-9961 346 Reputation points
2021-03-25T18:58:24.527+00:00 Hi Nandan,
Could you please provide me with a link that describes data sync between on premises SQL db to Azure SQL db.
Examples that I have seen on data sync mention syncing data from Azure SQL db to on premises db or from Azure SQL db to other Azure SQL dbs. I need data to be synced from on premises db to Azure SQL db.Thanks.
Salil -
Nandan Hegde 29,886 Reputation points MVP
2021-03-26T05:18:44.763+00:00 Hey @salilsingh-9961 ,
Based on my knowledge, data sync is bidirectional:
https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-sql-server-configure@KalyanChanumolu-MSFT : Can you please correct me if I am wrong
-
salilsingh-9961 346 Reputation points
2021-03-26T05:46:48.85+00:00 Hi @Nandan Hegde ,
I need sync to always happen in single direction from on premises SQL Server DB to Azure SQL DB.
In above mentioned link, SQL database is selected as hub database from which sync is happening to other Azure db and on-premises db. As mentioned earlier, I need sync to always happen in single direction from on premises SQL Server DB to Azure SQL DB.You know some option to achieve this?
Requesting to please correct me if my understanding on above mentioned link is incorrect.Thanks,
Salil -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma 17,571 Reputation points2021-03-26T09:03:02.13+00:00 You need to select the sync direction according to the requirement as shown in below screenshot from the same link. In your case, choice should be 'To the hub'.
Sign in to comment -