Database & Integration
Milestone integration is Suprema’s first VMS integration which allows users to be able to view access control events and manage doors directly from Milesto...
Mon, May 18, 2020 at 9:09 AM
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 ...
Thu, Mar 5, 2020 at 10:45 AM
MS SQL database includes MDF file and LDF file. MDF is actual data of an application and LDF file is a transaction log file which records the q...
Wed, Mar 4, 2020 at 9:15 AM
In the DB table t_lgyyyymm, you will see SRVDT but SRVDT is not event happened time. It is only the time the DB is synchronized to the server. Thus, you nee...
Wed, Feb 19, 2020 at 3:55 PM
The progress of BioStar2 Express Installation installs Maria DB 10.1.10, therefore BioStar2 SW is compatible with the version 10.1.10 of Maria DB. If yo...
Tue, Oct 1, 2019 at 1:23 PM
The user ID in BioStar 2 is USRID. Check the USRUID of the user in t_usr. BioStar 2 User ID = USRID = 1 USRUID = 1001 [t_usr] Check CRDTUID ...
Thu, May 9, 2019 at 11:13 AM
Warning: BioStar 2.5's automatic user synchronization feature will automatically synchronize the device with the server even before you click 'synch...
Wed, Apr 18, 2018 at 2:28 PM
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
This material will introduce you on exporting table contents into an excel file. *Before this event, you must be able to connect to your database on SQL...
Wed, Sep 19, 2018 at 3:24 PM
*This is for any users who are confused on how to view user information correctly on a database using SQL Server Management Studio - for database backup an...
Tue, Sep 18, 2018 at 2:32 PM