Databases

Databases

Below is a link to a utility that will upgrade an IS2000 Microsoft Access database to an IS2000 SQL Server database:  Click Here to Download   Steps to Follow on the Server: Before migrating IS2000 from an MS Access database to SQL Server, it is important to first close all…
By default, SQL Server 2005 Express Edition and SQL Server 2005 Developer Edition do not allow remote connections. To configure SQL Server 2005 to allow remote connections, complete all the following steps: * Enable remote connections on the instance of SQL Server that you want to connect to from a…
Data Import Tool    New Features Auto Scheduling Imports Importing of ODBC Allows for cancelling a Data Import that is in progress. Delete existing Personnel Record if Duplicate Card Number Update existing Personnel Record based on an index field Import from Lenel, Andover, and PointGuard. Check for duplicate cards. New…
Please Note:  Replication will only work on systems that are using SQL Server or SQL Express.  This application utility will only replicate the Data folder and SQL Database, this DOES NOT replicate the application software.Setup Steps:1)  Create an ODBC DSN on the Primary server that points to a Database on…
Below are query examples that you can enter in the Advanced Filter of the Personnel Manager module to return active and inactive cards.   Returning Active Cards Below is an example of how to return all active cards by taking the modulus of the User_Flag to tell us if Bit…
When installing IS2000, two (2) database options are available.  The first database option is Microsoft SQL Express and the second database option is Microsoft Access.  When considering what database option to use it is important to take into account the amount of database traffic such as events and alarms.  Microsoft…
Lenel Database Import function is built into the Data Import Utility.  This can import Hardware, Access Levels, Personnel records, and Personnel photos; however, Lenel has 3 different database versions.For all database conversions, we will need to have the database in-house for evaluation.  Once the customer agrees to the cost and…
Here are the general Access 97/2000 characteristics: Access Object Maximum sizes/numbers No. of concurrent users 255 No. of fields in a table 255 Database size 1 GB No. of characters in an object name 64 No. of characters in a password 14 No. of characters in a user name or…
If moving a SQL database, follow the steps outlined below: Close the application and make sure no drivers are running.  This can be done by checking the processes in task manager for the IS2000.exe, 12000.exe, 19000.exe processes.  Copy the Data Folder located in C:\Program Files\IS2000  Make a copy of the…
A backup can be performed from the client as long as the client has 'osql'.  This typically comes with SQL Server and/or the SQL Client Tools.  If the SQL Client Tools and/or SQL Server is NOT installed on the client PC then the SQL database will not get backed up…
Points for SQL Backup BackupPath MUST be located on the same drive letter as where SQL Server was installed. Backup function MUST be performed from the PC that has SQL Server installed. Below is the SQL Script used to perform the SQL Backup.  Please substitute the variables DB_Database, BackupPath, and…