Tutorial - Upgrading SQL Server

This guide contains a description of the steps to be taken to update the free version of SQL Server™ for database (version 2012 or earlier) of TachoScan to SQL Server™ 2017 Express (for Windows® 10 and 8.1), Windows Server® 2012 R2 or SQL Server™ 2014 Express (for Windows® 7, Windows®Server® 2008 R2).

Why to update SQL Server™?:
- "SQL Server™ 2000" and "SQL Server™ 2005" are not supported by TachoScan and Microsoft®
- for "SQL Server™ 2008" or later - change in database size limitation from 2GB to 10GB;
- for the "SQL Server™ 2008" or later - much improved performance.

 

Update of the program TachoScan

 

1.Update TachoScan to the latest version.

2.It is absolutely necessary to create a backup copy of database.

This upgrade window does not appear if the TachoScan database is connected to default or the latest version of SQL Server.

 

•Run DB Manager software (menu: "Start -> Programs -> INELO -> Utils -> Database Manager -> Database Manager);

<%TOOLTIP2%>

Fig. First launching.

This upgrade window does not appear if the database is connected to default or the latest version of SQL Server.

 

•click:

•log on to the program as an administrator;

Default password: "admin."

 

•in the program menu select: Backup -> Backup database;

•in the Database backup directory field, a path to the directory where you saved a copy of the database will be displayed by default - remember or write down this location;

If you want to change the backup path, go to advanced settings - see: "Database Manager -> Backup".

 

•click .

•wait until you see backup completed confirmation window:

<%TOOLTIP2%>

Fig. Backup confirmation.

•close Manager DB.

 

 

 

Upgrading SQL Server™

 

1.Run DB Manager software again on the server computer (menu: "Start -> Programs -> INELO -> Utils -> Database Manager -> Database Manager).

<%TOOLTIP2%>

Fig. Upgrade.

2.Click .

3.3.        In the next window, select the copy of the database you created in the previous step (a file with the "bak" extension):

<%TOOLTIP2%>

Fig. Database backup copy.

4.Click .

5.The program will start the download and installation:

•SQL Server™ 2008R2 Express - if TachoScan database was connected to MSDE 2000 or SQL Server™ 2005;

•SQL Server™ 2017 Express or SQL Server™ 2014 Express (depending on your operating system) - if the TachoScan database was connected to SQL Server™ version 2008R2 to 2012.

During and/or after installation, you may be required to reboot the computer.
If the computer reboots during installation, the installer will automatically resume operation.

 

6.After the installation of SQL Server™ is completed, you can run TachoScan.

During the installation of SQL Server™ an instance is be created, to which the one of the following automatically connects:
- INELO08 - for SQL Server™ 2008R2;
- INELO14 - dla SQL Server™ 2014.
- INELO17 - for SQL Server™ 2017.

To prevent accidental connection to the old database, the update program disconnects it from the previous version of SQL Server™.
Both the previous version of SQL Server™ and the database are not removed during the upgrade.
After checking if TachoScan is working properly and data is complete, you can uninstall the old version of SQL Server™ and remove the old database.

Service version:
If you want the database backup copy to be created using INELO Service then during the first linking of each database, check the Jobs schedule executed by: -> INELO Service option ("Basic data -> Settings" menu, "Administration panel -> Database backup settings" tab).

 

7.If you wanted to update your SQL Server to SQL Server™ 2017 Express / SQL Server™ 2014 Express but the program has updated it only to: SQL Server™ 2008R2 Express:

•restart DB Manager - repeat steps 2 to 6.

After a successful update, you can uninstall SQL Server™ 2008R2 Express.