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.6 Database Table
Please refer to the attached file regarding BioStar's Database table.  The document also includes precautions regarding database use provided by ou...
Tue, May 8, 2018 at 4:53 PM
[BioStar 2] Changing the root password of Maria DB
The root password is configured when you install BioStar 2.3 and above. If you forgot your root password, you can reset it by following the instructions bel...
Tue, May 30, 2017 at 4:55 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  and there i...
Thu, Dec 7, 2017 at 8:41 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...
Mon, Jan 15, 2018 at 4:16 PM
[BioStar 2] MariaDB Access and Account Configuration
In BioStar 2.4.1, the following security measures will be introduced (2017 Q2):  External access to Maria DB is blocked by default Only Administr...
Mon, Oct 16, 2017 at 4:55 PM
[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....
Thu, May 3, 2018 at 5:49 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...
Mon, May 21, 2018 at 3:47 PM
[BioStar 2] Script / Manual Database Backup (Maria DB)
We recommended to use MySql Workbench tool to backup and restore your database as shown in the link: [BioStar 2] Database Backup and Restore Instructions . ...
Thu, Dec 21, 2017 at 3:40 PM