Tag Archives: SQL 2008

Transactional Replication Filters

I recently needed to replicate a small portion of a database to a separate server hosting SharePoint. Only a small amount of our total user base would be able to access this site, so we decided to use Transactional replication to replicate only the users with the proper roles. This presented a few unexpected challanges, as the filters did not work as you might expect.

Posted in Replication, SQL | Tagged , , | Leave a comment