TOXICALL® Archiving Cases

Prepared by

Computer Automation Systems, Inc.

Aurora, Colorado                    © 2013 All Rights Reserved

Contents

TOXICALL® Archiving Cases. PAGEREF _Toc358365320 \h 1

Introduction. 3

Create an Archive Database. 3

SQL Server 3

Microsoft® Access Database. 6

Configure an Archive Database within TOXCALL®.. 6

Check for Structure Updates / Copy System Tables. 10

Check for Structure Updates 11

Copy System Tables 12

Moving or Copying Cases to an Archive Database. 13

Fast Copy Option. 16

Verify Source and Destination Database Reside on Same Server 16

Create ToxTemp Data Table on Destination Database. 17

Performing a Fast Copy. 19