Database & Integration

[BioStar 2] Troubleshooting BioStar 2 MSSQL Installation Issues
BioStar 2 MS SQL version is available starting BioStar 2.4.1.  You cannot upgrade from an older Maria DB version BioStar 2 to MS SQL database version BioSt...
Mon, Oct 18, 2021 at 11:25 PM
[BioStar 2] Automatic backup Maria DB
Automatic backup Maria DB   The recommended backup route will always be MySql Workbench (Linked Here) as it offers more control with the dB. Recently, ho...
Wed, Sep 22, 2021 at 1:49 AM
[BioStar 2] BioStar DB Migration Tool - Beta Version with More Logs
With the end of BioStar 1 technical support, Suprema has provided a DB Migration Tool for customers to conveniently move from BioStar 1 to BioStar 2. (BioSt...
Thu, Apr 15, 2021 at 4:08 PM
[BioStar 1] How to Delete Old Logs From Biostar 1 Database
Depending on each company, country, or region, it may be necessary to delete old user logs according to security policies. For this case, you can delete th...
Thu, Mar 25, 2021 at 3:23 PM
Integration with Ticket printer and Suprema Devices
Some customers want to issue the ticket after authentication on Suprema devices for managing the meal count. We introduce the procedure of how to integrate...
Tue, Mar 9, 2021 at 9:15 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...
Wed, Oct 21, 2020 at 1:25 PM
[BioStar 2] Troubleshooting BioStar 2.2.1/2.2.2 DB Migration Fail
Cause:  This issue will occur if you already attempted to migrate your Sqlite database to Maria DB before (upgrading 2.2.1~2 to 2.3) and then you tried to ...
Wed, Oct 14, 2020 at 11:23 AM
[Both BioStar] Integration Options for 3rd Party Controllers
This article describes the ways you can use Suprema devices with 3rd party controllers. Using BioStar + 3rd Party AC Platform This method is by far ...
Fri, Aug 28, 2020 at 6:47 AM
[BioStar 2] How to Export Database Table into an Excel File (Maria DB Database Example)
This material will talk about how you can export database table into an excel file for BioStar 2. *Before this material, you must be able to access Mari...
Mon, Aug 3, 2020 at 11:43 AM
[BioStar 2] MariaDB Access and Account Configuration
Default Security Measures Introduced in BioStar 2.4.1 (2017 Q2)  External access to Maria DB is blocked by default [root account only has localhost / 12...
Wed, May 20, 2020 at 11:06 AM