patternsqlMinor
Mirror / replicate only 1 table of a database
Viewed 0 times
replicatemirrordatabaseonlytable
Problem
I need a good way to replicate a single table in SQL Server 2012 between different servers and different databases. I tried replica which works just fine, but there might be a much better / easier way which I don't see right now.
Maybe there is a way to use the task to import data as a job. The data does not need to be synchronized all the time. It is fine that the second database [B] gets updated with the data from database [A] every 5-10 minutes.
Is it possible to setup a mirroring for only one table?
Of course I checked the web which gave me the idea to script the import task.
What else is possible and how?
Maybe there is a way to use the task to import data as a job. The data does not need to be synchronized all the time. It is fine that the second database [B] gets updated with the data from database [A] every 5-10 minutes.
Is it possible to setup a mirroring for only one table?
Of course I checked the web which gave me the idea to script the import task.
What else is possible and how?
Solution
You can use snapshot replication (it allows you to update the table every 5-10 minutes). If you would like instant changes, go for transactional replication.
Note that you cannot publish a replication on SQL Server Express, you need at least Standard edition.
Note that you cannot publish a replication on SQL Server Express, you need at least Standard edition.
Context
StackExchange Database Administrators Q#91888, answer score: 2
Revisions (0)
No revisions yet.