I have a business scenario where web site and SQL database will be on cloud and after some operations want to save the cloud SQL data to the SQL database which is on-premises and not exposed to the internet.
我有一个业务场景,其中网站和SQL数据库将在云上,并且在一些操作想要将云SQL数据保存到本地且不暴露于互联网的SQL数据库之后。
What would be the best architecture for this scenario?
这种情况的最佳架构是什么?
Need suggestions.
2 个解决方案
#1
1
you can either setup a VNET to connect your Website to your on-premises SQL Server or you can configure Azure Hybrid Connect. (see this link)
您可以设置VNET以将您的网站连接到本地SQL Server,也可以配置Azure Hybrid Connect。 (见这个链接)
#2
0
If the website does not use local resources you can always go for azure websites. Choose the tier based on the requirement.
如果网站不使用本地资源,您可以随时访问azure网站。根据要求选择层级。
As far as the database is concerned you choose azure sql database. ( tier based on requirement-size and performance) . You can set up azure sql sync (in preview) to sync between sql azure and local sql server. Or you can take a back up of sql azure db - bacpac. and then restore it local sql server using sql management studio.
就数据库而言,您选择azure sql数据库。 (根据需求大小和性能分层)。您可以设置azure sql sync(在预览中)以在sql azure和本地sql server之间进行同步。或者你可以备份sql azure db - bacpac。然后使用sql management studio恢复本地sql server。
#1
1
you can either setup a VNET to connect your Website to your on-premises SQL Server or you can configure Azure Hybrid Connect. (see this link)
您可以设置VNET以将您的网站连接到本地SQL Server,也可以配置Azure Hybrid Connect。 (见这个链接)
#2
0
If the website does not use local resources you can always go for azure websites. Choose the tier based on the requirement.
如果网站不使用本地资源,您可以随时访问azure网站。根据要求选择层级。
As far as the database is concerned you choose azure sql database. ( tier based on requirement-size and performance) . You can set up azure sql sync (in preview) to sync between sql azure and local sql server. Or you can take a back up of sql azure db - bacpac. and then restore it local sql server using sql management studio.
就数据库而言,您选择azure sql数据库。 (根据需求大小和性能分层)。您可以设置azure sql sync(在预览中)以在sql azure和本地sql server之间进行同步。或者你可以备份sql azure db - bacpac。然后使用sql management studio恢复本地sql server。