CODEWITHSUNDEEP
sqlsql-server
Michael Seltene
Michael Seltene

Reputation: 591

Syncing data between 2 SQL Server tables

I have 2 servers. One used for backup as well as sharing with other external users and the other for live queries internally.

At the moment, on the backup database, the existing table is dropped and new table is added using the below code:-

DROP TABLE [dbo].[test]
SELECT * INTO test FROM [remote server].[remote database].[dbo].[remote table];

Is there another method instead of dropping and adding tables. Ideally, something that looks for any changes and syncs them using SQL Server Management Studio.

Edit: My server is Express Edition and remote is SQL Standard

Upvotes: 0

Views: 217

Answers (1)

JERRY
JERRY

Reputation: 1173

If you want to sync two tables in simplex communication way(One Directional) then you should go with transaction replication.
Sync will be performed on transaction commit for particular row.

Upvotes: 2

Related Questions