Developer technologies | .NET | Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
Sync data of Table A between SQL Server 1 and SQL Server 2
![](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(51.2, 18%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
John Pike
1
Reputation point
One is live and SQLSVR2 is a backup. From time to time, I may need to switch them so I am writing a sync application that uses ADO .Net to read the modified/new rows from SQLSVR1->Table A and update/insert/delete them from SQLSVR2->Table A. These tables have a lot of columns(250+) which is why I want to use ADO. I was using the MS Data Set Generator to generate the dataset/data tables for me. The problem that I am having is that I cannot copy one data table from SQLSVR1 to a data table from SQLSVR2. I thought that I could use the UPDATE, DELETE and INSERT methods in the appropriate data adapter if I could populate the data table on SQLSVR2. Has anyone ever tried to do this or can anyone suggest an alternative solution?
Developer technologies | .NET | Entity Framework Core
Azure SQL Database
Azure SQL Database
An Azure relational database service.
Developer technologies | .NET | Other
Developer technologies | .NET | Other
Microsoft Technologies based on the .NET software framework. Miscellaneous topics that do not fit into specific categories.
Developer technologies | C#
Developer technologies | C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
{count} votes
-
![](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(57.599999999999994, 16%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWG%3C/text%3E%3C/svg%3E)
Wenbin Geng 746 Reputation points Microsoft External Staff2023-09-01T09:46:32.2466667+00:00 Hi, using programming methods to synchronize databases is often thankless. If two databases are on the same server, triggers can be used to easily achieve data synchronization. Are SQLSVR1 and SQLSVR2 here Azure SQL Database? Are they on the same server?
-
![](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(137.6, 63%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOK%3C/text%3E%3C/svg%3E)
Oki Kuswanda 0 Reputation points2023-09-01T11:56:12.82+00:00 You can use Azure database sync, which is a feature on Azure SQL databases. Based on my experience with database B, I delete the foreign key and primary key. If the database is large, such as 200GB, it will take time to sync all tables.
Sign in to comment
Sign in to answer