-1

How I can do live replication of few tables in SQL Server?

The reason why I would like to achieve this is so that I can run SQL Statements on those tables without worrying about the table being locked

  • Have you read up on transactional replication? – Nic Nov 15 '16 at 14:35
  • Nope, but certainly going to do so now. Thanks Nic – user2040021 Nov 15 '16 at 14:42
1

I would suggest start at

https://msdn.microsoft.com/en-us/library/ms179855.aspx

This link gives detailed steps for implementing replication

http://www.codeproject.com/Articles/715550/SQL-Server-Replication-Step-by-Step

Not the answer you're looking for?Browse other questions tagged or ask your own question.