BioStar 2 - How to migratie DB logs from BioStar 1 to BioStar 2

BioStar 2 - How to migrate DB logs from BioStar 1.x to 2

This document will guide you through the process of how to migrate logs from BioStar 1.x to BioStar 2 using the DB migration tool. Please carefully read and follow the instructions.

Limitations

  • This migration tool currently does not support migration to Oracle DB.
  • For BioStar 1.x DB, only authentication logs are transferrable.


Preparations

1. The authentication for the SQL Server must be done as SQL Server AuthenticationWindows Authentication is not supported. Login ID and PW in required in the later instruction. If you don’t know how to create a SQL server authentication login ID, please refer to How to create a SQL server authentication login ID document. 

2. Run the SQL Server Configuration Manager. On the left pane, click SQL Server Services and check the state of the SQL Server Browser. It has to be Running


3. The authentication for the SQL Server must be done as SQL Server AuthenticationWindows Authentication is not supported. Login ID and PW in required in the later SQL Server Network Configuration. Then, click the Protocols for SQLEXPRESS and check if the TCP/IP is Enabled


If you have changed any of the settings above you will have to restart the SQL Server. 



Migrating logs from BioStar 1.x DB to BioStar 2 DB

1. Run Services from your Windows Control Panel. (Control Panel > Administrative Tools > Services


2. Search for BioStar 2 Launcher Service


3. Right-click BioStar 2 Launcher Service and click Stop. Then the Status now would become blank. 


4. Go to config folder in the migration tool path. Open logConfig.mssql


5. Copy the content and paste it in logConfig file. 


6. In logConfig file, fill the log starting/snding monthuserpasswordserverportdatabase information of your BioStar 1.x DB system and save it. 


7. Go to BioStar2 installation folder (C:\Program Files (x86)\BioStar 2) and go to db folder. 


8. Copy the biostar2.db file and paste it in the db folder in the migration tool folder. 


9. Go back to B2DM folder. Shift+Right-click then click Open command window here


10. Type run_log.bat and enter. 


11. You will see migration logs. 


    • Related Articles

    • BioStar 2 - How to use the DB Migration Tool

      This document will guide you through the process of how to use the DB migration tool. This DB migration Tool will be helpful to convert user information of BioStar 1.x to user information of Biostar 2.x. Please read the manual carefully and follow ...
    • BioStar 2 - How to backup and Restore the Maria Database in BioStar 2

      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.1, the MariaDB T&A database was released.  Starting version 2.3, both databases became Maria DB by ...
    • BioStar 2 - How to backup and Restore the Database in BioStar 2

      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.1, the MariaDB T&A database was released.  Starting version 2.3, both databases became Maria DB by ...
    • BioStar 2 - Maria DB 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 / 127.0.0.1 connection privilege] This means you can only configure the Host as 127.0.0.1 or localhost ...
    • BioStar 2 - How to update to a newer version

      BioStar 2 supports direct upgrade from the 2.5v to the latest version.  If your BioStar 2 version is 2.5v or higher, you can just download the latest version and conduct an upgrade.  However, you cannot upgrade from a very old version such as 2.0 to ...