Laserfiche WebLink
Chapter 3 - System Components <br />10.4.2 INFORM CAD DATA ARCHIVING & REPORTING SERVER — (SQL REPLICATION <br />WITH COMPREHENSIVE DATA PURGING) <br />This version of SQL replication combines near real-time automatic duplication of the Inform Database data with <br />comprehensive data purging. Comprehensive data purging allows the customer to remove data not needed for <br />daily operations while retaining appropriate, contractual amounts of data (like 90, 180, or 365 days) to create a <br />smaller, faster -reacting production database. <br />In the case where the Archive & Reporting Server is not the same version of SQL as the Inform Database server <br />and Distribution database resides on the Archive & Reporting server; the Archive & Reporting server needs to be <br />the higher version of SQL. <br />Note: The aggressive use of purging can increase the need for database re -indexing. <br />The purging tools are installed in a way that allows data on the destination (Subscribing) databases to build up <br />over time for historical ad -hoc reporting purposes, while maintaining a smaller and quicker production databases <br />for CAD operations. This functionality is achieved by keeping production database deletions from being carried <br />out on the destination databases. <br />10.5 INFORM CAD TRAININGITESTING SERVER <br />The Training/Testing Server is designed to allow clients to perform training or testing of new versions of Inform <br />CAD and configuration changes. The OS version and DB version should match the production version. The only <br />exception to this is when the customer is testing a new version of Inform with a new OS/DB configuration. <br />The Training/Testing System is an excellent setting to test new OS versions, security profiles and third party <br />software prior to deploying in the production environment. <br />The contents of this material are confidential and proprietary to TriTech Software Systems, Inc. and may not be reproduced, <br />published or disclosed to others without the prior written consent of TriTech Software Systems, Inc. <br />92015 TriTech Software Systems <br />