Database & Integration

[BioStar 2] BioStar 1 to BioStar 2 Database Migration
Unfortunately there currently isn't a simple migration tool that allows upgrade straight from BioStar 1.9 to the current BioStar 2 version. The migrati...
Thu, Apr 15, 2021 at 4:14 PM
[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
[BioStar 2] BioStar 2 Database Table Information (DB Link)
Updated: 01 Feb 2021 Please refer to the attached file regarding BioStar's Database table.  The document also includes precautions regarding datab...
Wed, Mar 17, 2021 at 12:39 PM
[BioStar 2] Supports Windows Authentication for MS SQL Database Server Connections
    From BioStar 2.7.14, Windows Authentication Mode for MS SQL database Connection is supported. To use the Windows Authentication mode in your BioStar 2 S...
Wed, Mar 10, 2021 at 3:02 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
[BioStar2] Alternate BioStar 2 Backup Tool
The recommended backup route will always be MySql Workbench (Linked Here) as it offers more control with the dB. Recently, however, the CMD backup applet ...
Mon, Feb 8, 2021 at 8:24 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