3 Replies Latest reply on Nov 28, 2011 12:51 PM by fealves78

    Keeping a cache cluster in sync with MSSQL Server database

    fealves78 Newbie

      I wonder what would be the best approach for keeping my cache cluster in sync with a MSSQLServer database.  The cache will be used mostly for reading. However, the database will suffer updates with variable frequency throughout the day.


      I am thinking about using MSSQLServer 2008 R2 new features such as Change Data Capture and Change Tracking (http://www.microsoft.com/download/en/details.aspx?id=21599), but I wonder if there is a better and more generic approach (compatible with older versions of MSSQLSever) for keeping the cache synchronized.


      Any thoughts?