<< Click here to display Table of Contents >> Navigation: Supplementary information > Engine module:

Tutorial - Upgrading SQL Server

Contents

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™ 2014 Express.

Why to update SQL Server™?:
- "SQL Server™ 2000" and "SQL Server™ 2005" are not supported by Microsoft® - after every update of Windows® you may experience problems with SQL Server;
- 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.

A copy of the database can be made only on the computer on which TachoScan database is located.

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

Fig. First launching.

This upgrade window does not appear if the database is connected to SQL Server™ 2014 or later.

•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:

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).

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):

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™ 2014 Express - if TachoScan database was connected to SQL Server™ 2008R2 or SQL Server™ 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 - for SQL Server™ 2014.

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™ 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.