question

salilsingh-9961 avatar image
0 Votes"
salilsingh-9961 asked AnuragSharma-MSFT commented

Migrating onpremises SQL Server Database to Azure SQL Database

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.

  1. What are the mostly used and cost effective options which are used when migrating on-premises SQL Server database to Azure SQL Database?

  2. 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?

  3. 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?

  4. It will be really helpful if you provide links/ example for this.

Thanks,
Salil



azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered AnuragSharma-MSFT commented

You can use Data Sync to sync your On Prem Database to Azure SQL database

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

Hey @salilsingh-9961 ,
Based on my knowledge, data sync is bidirectional:
https://docs.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

0 Votes 0 ·

Hi @NandanHegde-7720,

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

0 Votes 0 ·
Show more comments