Mirror / replicate only 1 table of a database

Posted on

Question :

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?

Answer :

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.

Leave a Reply

Your email address will not be published. Required fields are marked *