Database & Integration

[BioStar 1] How to update an existing MS SQL database using DBSetup
TS0001 – How to update an existing MS SQL database using DBSetup APPLIES TO: BioStar How to update an existing MS SQL database using DBSetup   This doc...
Wed, Apr 5, 2017 at 11:12 AM
[BioStar 2] BioStar 2 Database Table Information (DB Link)
Please refer to the attached file regarding BioStar's Database table.  The document also includes precautions regarding database use provided by ou...
Tue, Oct 6, 2020 at 2:28 PM
[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...
Mon, May 4, 2020 at 10:09 AM
[BioStar 1] Database Table and DB Link Instructions
Please refer to the TS0119 attachment regarding DB Link integration. You can also refer to TS0168 for a more detailed database table information. * There ha...
Fri, Aug 3, 2018 at 11:15 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
[BioStar 2] Database Backup and Restore Instructions (Maria DB)
BioStar 2's database has gone through a few changes since it's release.  The AC database started out with the SQLite Database and in version 2.2....
Tue, Apr 7, 2020 at 4:55 PM
[Both BioStar] MS SQL Database Backup and Restore Instructions (Redirected Link)
This document was originally for both BioStar 1 and 2, but it has been separated to two different articles to avoid confusion with the additional  backup i...
Wed, Apr 25, 2018 at 5:03 PM
[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...
Wed, Mar 13, 2019 at 4:55 PM
[BioStar 2] Maria DB Automatic Backup Configuration (BioStar 2.4.1)
Disclaimer We can provide very limited assistance if this script fails. If this script fails please consider using the MySQL Workbench to back up your datab...
Wed, Apr 18, 2018 at 2:28 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