Unfortunately there currently isn't a simple migration tool that allows upgrade straight from BioStar 1.9 to the current BioStar 2 version. The migration options available are as below.  


Note: FaceStation 1 templates are not compatible with FaceStation 2 because the algorithm and template size is different.


Option 1 : New DB Migration Tool


From BioStar v2.6, new DB migration tool is included into the installation folder of BioStar 2.

Path: C:\Program Files\BioStar 2(x64)\biostar-migration\

BioStar 1.x to BioStar 2.x Migration Tool allows you to migrate user data and event logs from BioStar 1.x into BioStar 2.


Note:

• BioStar 1.x to BioStar 2.x Migration Tool is available on PCs with BioStar 1 and BioStar 2 installed.

• BioStar 1.x to BioStar 2.x Migration Tool supports data migration from BioStar 1.9 or later to BioStar 2.6 or later.

• BioStar 1.x to BioStar 2.x Migration Tool is available only on 64bit operating system.

• When migrating data using BioStar 1.x to BioStar 2.x Migration Tool, existing users stored in BioStar 2 will be deleted

except for user 1.


You need to take the following steps: 

1. Upgrade BioStar 1.x to BioStar 1.9 or 1.9x correctly (How to upgrade BioStar)

2. Just in case, make a backup DB of BioStar 1.9 or 1.9x

3. Stop BioStar 1 Server and Install BioStar 2 

4. Go to C:\Program Files\BioStar 2(x64)\biostar-migration\ and find the PDF guide of DB migration.

Refer the BioStar 1.x to BioStar 2.x Migration Tool_QG_V1.00_EN.pdf inC:\Program Files\BioStar 2(x64)\biostar-migration or the link here.




Option 2 : Transfer Users with a 2nd Generation Device


The easiest way to migrate users & fingerprints (the migration tool doesn't migrate the logs either) is to use a 2nd generation device (BioStation 2, A2, L2) on 1.93 and upload the users to BioStar 2.x. 

 

*You cannot use W2, it will not store the names of users. 


You need to take the following steps: 

 

1. Transfer all users to 2nd generation device in BioStar 1.93

** You cannot use a entry level device, since you have to upgrade the firmware and that process sets the device to factory reset.


2. Disconnect the device from BioStar 1. 


3. Connect the device to BioStar 2. 


4. Upload all users in the device to server. 


You will now have users' fingerprints, CSN card, and compatible user information in BioStar 1. Department information is not migrated because the concept is different in BioStar 2 and no logs are imported as well. 


Caution: If you have users with a expiry date after 12/31/2030, they might not migrate properly because BioStar2 only allows up to 12/31/2030. In that case please run the query below before going through with the tool to change all exceeding expiry date to 12/31/2030


Use BioStar;

UPDATE dbo.TB_USER SET nEndDate = '1924988400' WHERE nEndDate > '1924988400';


Also please make sure that the start date is not earlier than 01/01/2001 before you transfer all users to 2nd generation device in BioStar 1.93.



Option 3: DB Migration Tool (Out of Date)

Note: This does not support migration to MS SQL. If you plan to use MS SQL with BioStar 2, use Option 2 above. 

** The option 3 is too old to use the recent version of BioStar 2.  Please create a ticket if you need to use the tool.


1. Upgrade BioStar 1.x to BioStar 1.9 correctly (How to upgrade BioStar)

2. Use DB Migration tool to migrate 1.9 to 2.2.2. Back up your database before starting: How to Backup Your Database 


You can download the migration tool in the link below and refer to the attachment(TS0102 - BioStar2- How to use the DB migration tool_cr.pdf).

DB Migration Tool ** The tool is too old to use recent version of BioStar 2. Please create a ticket if you need to use the tool.

** Please take note of the cautions in the documentation. Not all user data will be migrated to BioStar 2. 


3. Install BioStar 2.2.2 (download link)

4. Upgrade to the recent BioStar 2 with instructions shown in the following link.


Please note that BioStar 2 does not have identical features as BioStar 1. For example, zones and T&A features are different in BioStar 2.

Refer to the limitations in the following link

Kindly check the specifications of the project and test BioStar 2 thoroughly before deploying it to your sites if you are not familiar with the system. 



Caution: If you have users with a expiry date after 12/31/2030, they might not migrate properly because BioStar2 only allows up to 12/31/2030. In that case please run the query below before going through with the tool to change all exceeding expiry date to 12/31/2030


Use BioStar;

UPDATE dbo.TB_USER SET nEndDate = '1924988400' WHERE nEndDate > '1924988400';