ReplTip – Subscribe to “all” restriction using “Initialize with backup” Chris Skorlinski Microsoft SQL Server Escalation Services I ran into a couple of challenges using the Backup\Restore method to setup a SQL Server Replication Subscriber. In particular, using this method you are unable to subscribe or un-subscribe to an individual article. Using Backup\Restore you mush
Read More »
ReplTip – Bulk Updates with Transactional Replication by Taiyeb Zakir We’re seeing several customers performing bulk updates on the Publisher. Consider for example a table with 10 rows and 2 columns C1 and C2 and we run this update. Update table set C1 = “Something” This updated 10 rows as one set, but when Log
Read More »
ReplTip — Showing pending change for Merge Replication by Sateesh Yele, SQL Server Escalation Services We often get merge replication cases where the merge agent is running for long durations and customer would like to know the pending changes at both publisher and the subscriber that the merge agent has to replicate. We do have
Read More »
ReplTip — Only one Log Reader can connect message when dropping a Publication by Taiyeb Zakir Sometimes when you try to drop a Transactional Publication using the GUI, you get the following error: Only one Log Reader Agent or log–related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) can connect to a database at a time. If you
Read More »
ReplTip — Attunity CDC to replace Oracle Publishing By Taiyeb Zakir Microsoft SQL Escalation Support Starting with SQL 2012, Heterogeneous Replication to non-SQL Server Subscribers and Oracle Publishing is deprecated. To move data from Oracle to SQL, Attunity provides a feature called Change Data Capture for Oracle and it is shipped with SQL 2012
Read More »