Manual

INTELLITRACK CHECK IN-OUT V8.1
User Manual
xviiixviii
Database Backup and Restore with SQL Server/SQL Express ........................419
Database Backup with SQL Server Management Studio ..........................419
Database Restore with SQL Server Management Studio ..........................427
IntelliTrack Backup and Restore Database Utilities ........................................435
Batch Utilities ............................................................................................435
Databackup Folder Permissions.................................................................437
APPENDIX C: Compact Workstation Utility ......................................443
Overview ..................................................................................................................444
Compacting the Workstation Application File.........................................................444
APPENDIX D: Manual IIS Setup .......................................................445
Overview ..................................................................................................................446
Manual IIS RDA Setup Requirements.....................................................................446
Manually Configuring IIS on Windows XP or
Windows Server 2003 Operating Systems........................................................ 447
Setting up IIS v6.0 to Allow the DMS Web Service Extension........................ 448
Manually Configuring IIS on Windows Vista /Windows 7/ Windows Server 2008
Operating Systems ............................................................................................450
Setting Up IIS v7.0 to Allow the DMS Web Service Extension....................... 451
Configuring the IntelliTrack Application Pool ................................................. 458
APPENDIX E: Checking IIS Setup ....................................................463
Overview ..................................................................................................................464
Reaching the Batch Synchronization Utility............................................................ 464
Sync URL Setting ............................................................................................. 465
APPENDIX F: Microsoft Access Integration .....................................469
Introduction .............................................................................................................. 470
Full Access Import ................................................................................................... 470
Import Access Inventory Data.................................................................................. 471
Query Import Data – Site Table ........................................................................474
Query Import Data – Bin Location Table ......................................................... 474
Query Import Data – Inventory Table............................................................... 475
Query Import Data – TblCheck Table............................................................... 476
Query Import Data – Inventory by Location Table...........................................477
Exporting Data ......................................................................................................... 478
Custom Reports ........................................................................................................478
2283.book Page xviii Thursday, July 7, 2011 2:29 PM