question

DylanSheth-9766 avatar image
0 Votes"
DylanSheth-9766 asked DylanSheth-9766 answered

SQL in azure

Hi,
If any can guide me.
We have on perm SQL database we use for our online application.
We want to migrate both to Azure.
Now Question I have is when I editing/updating Live database it will lock application.
So Idea was to Create a snapshot for application and then update live database, replace spanshot again.
Is there any way i can use for above scenario ?

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.

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

You can create an Azure SQL Database that synchronize with your on-premise database using Azure SQL Data Sync (click here to know how it can be configured). You can configure bi-directional Sync between on-premises SQL Server and the Azure SQL database. Once this is configured, if your application cannot connect to one database (on-premises for example) it can be programmed to try instead to connect to Azure SQL as second option, or vice versa.

You can also have 2 Azure SQL Database in sync. You can configure them to sync every XX seconds, minutes, hours, days, etc.

Azure SQL Data Sync service is free, you just have to pay for the 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.

DylanSheth-9766 avatar image
0 Votes"
DylanSheth-9766 answered

Hi Alberto,
So when sync is happening. does it will lock all the tables and application cant be used at syncing time ?

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.