Category Archives: SQL Server Replication

Step by Step Procedure to Implement SQL Server Transactional Replication with Oracle as Publisher

I come across interesting article which provides the step by step details to create Transactional Replication with Oracle as Publisher by Gurwinderjit SinghSE, Microsoft SQL Server…   Step by Step Procedure to Implement SQL Server Transactional Replication with Oracle as … Continue reading

Posted in SQL Server Replication | 59 Comments

2 TB ERP Databases using SQL Server 2008 Replication

2 TB ERP Databases using SQL Server 2008 Replication   Case Study Baltika Breweries Russia’s Baltika Breweries Links its ERP Databases using SQL Server 2008 Replication Baltika Breweries, the largest producer of beer in Russia, has about 12,000 employees and … Continue reading

Posted in SQL Server Replication | 73 Comments

How the log reader agent works….

How the log reader agent works explanation by Michael Hotek   http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1525976&SiteID=1   When you have a database in simple recovery model, the committed transactions log are thrown away with each checkpoint.  It does this by starting at the beginning … Continue reading

Posted in SQL Server Replication | 53 Comments