Database & Integration

[BioStar 1] Automatic Event Log Table Backup Feature in BioStar 1.93 (TB_EVENT_LOG_BK)
A new log backup feature has been introduced in BioStar 1.93.  This does not mean the database is being backed up automatically. For that procedure please ...
Thu, Jul 5, 2018 at 4:55 PM
[BioStar 2] How to install Oracle DB on BioStar2 v2.4.1
Caution: BioStar2 discontinued to support Oracle DB. This document is for BioStar2 v2.4.1 user. BioStar2 v2.4.1 supports Oracle DB for small size projec...
Thu, Dec 28, 2017 at 3:23 PM
[BioStar 1] How to convert time and date stored in nDateTime of TB_EVENT_LOG table
How to convert time and date stored in nDateTime of the TB_EVENT_LOG table to a normal format nDateTime  The number of seconds that have elapsed since ...
Wed, Apr 11, 2018 at 3:20 PM
[BioStar 1] Device Disconnection When Event Log Table Has More Than 10 Million Logs
Once more than 10 million logs are gathered, devices may start to have connectivity issues because the BioStar database has too many logs. In this case you ...
Mon, Jan 29, 2018 at 4:53 PM
[BioStar 1] Image Logs in the Database
Image log is a feature available for T2, X-Station, FaceStation, D-Station for capturing a picture when there is a specified event.  If you're...
Wed, Apr 25, 2018 at 5:09 PM
[BioStar 2] Image Log in the Database
The image log captured on devices with cameras on specified event is not stored in the database but in a separate folder in the BioStar 2 directory.  ...
Wed, Jul 4, 2018 at 4:34 PM
[BioStar 2] Checking T&A Logs in the T&A Database
If you are considering to create a database link program with BioStar database with your third party software, please do not take logs from the T&A data...
Mon, Oct 8, 2018 at 2:59 PM
[BioStar 1] Why nUserID of TB_EVENT_LOG is minus?
(Problem) When you confirm the data of nUser ID from TB_EVENT_LOG, some user ID could be "-" at the front of the user ID. (Description) I...
Tue, Apr 10, 2018 at 8:37 AM
[BioStar 2] MSSQL Database Backup and Restore Instructions
License Backup If you would like to re-use your BioStar 2 license, refer to the following article: [BioStar 2] Reactivating the License Backup Instruct...
Mon, Dec 24, 2018 at 4:56 PM
[BioStar 1] MSSQL Database Backup and Restore Instructions
Backup Instructions You can back up the BioStar database on Microsoft SQL Server Management Studio Express. You can download it at
Wed, Apr 25, 2018 at 4:56 PM