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 (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, Jun 12, 2018 at 9:58 AM
[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, May 31, 2018 at 8:59 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, Aug 8, 2018 at 5:05 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....
Mon, Aug 13, 2018 at 1:17 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