admin管理员组

文章数量:1122832

I have a SQL server in Azure:

Az-SQL-SRV1
-> Az-DB-1
-> Az-DB-2

My app is always connecting to Az-DB-1 by design and Az-DB-2 is a backup DB. I want to always sync the Backup DB Az-DB-2 so that in cases when I have to switch from Primary to Backup I don't have to worry about the data loss.

Can't use Geo-Replication as both DB are in same zone and same SQL server.

I have a SQL server in Azure:

Az-SQL-SRV1
-> Az-DB-1
-> Az-DB-2

My app is always connecting to Az-DB-1 by design and Az-DB-2 is a backup DB. I want to always sync the Backup DB Az-DB-2 so that in cases when I have to switch from Primary to Backup I don't have to worry about the data loss.

Can't use Geo-Replication as both DB are in same zone and same SQL server.

  • sql-server
  • azure
Share Improve this question edited Nov 22, 2024 at 21:48 Thom A 95.3k11 gold badges59 silver badges92 bronze badges asked Nov 22, 2024 at 21:12 rehmanrehman 191 silver badge7 bronze badges 3
  • Having a replica on the same environment generally isn't how you do things. This sounds like an XY Problem. What would you be doing in the "primary" database that would mean you need to fall to the secondary on the same server? If you make changes to the secondary and you expecting for those to then be pushed to the primary? – Thom A Commented Nov 22, 2024 at 21:56
  • 1 Is it SQL Server on Azure VM or SQL Server Managed Instance or Azure SQL? – Shanmugam Sudalaimuthu Commented Nov 22, 2024 at 22:10
  • why would you want to sync two dbs on the same server ? – Thomas Commented Nov 23, 2024 at 8:40
Add a comment  | 

1 Answer 1

Reset to default 0

SQL Data Sync is a service built on Azure SQL Database that lets you synchronize the data you select bi-directionally across multiple databases.

To setup SQL Data Sync Follow below procedure:

  • Go to your Azure SQL database that need to be replicated in azure portal, go to Data Management >> Sync to other databases >> New Sync Group.
  • Fill the required Data as below

本文标签：

版权声明：本文标题：How to sync data between from a SQL DB in Azure SQL Server to another SQL DB in a same Azure SQL Server - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736300831a1930960.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。