Menu ▾ ▴

Install and Configure Virtuoso

Dušan Rychnovský Mifeet

To install and configure Virtuoso on a 32-bit Windows machine to be used within your development environment, follow the steps below.

1]

Download the precompiled binaries at virtuoso.openlinksw.com.

2]

Unpack the downloaded zip to a local directory (e.g. C:\Tools\virtuoso-opensource).

3]

Set up some environmental variables to ease further steps:

  • VIRTUOSO_HOME -> c:\tools\virtuoso-opensource
  • PATH -> %PATH%;%VIRTUOSO_HOME%\bin;%VIRTUOSO_HOME%\lib

4]

Download the data spaces' configuration files from the SourceForge repository and put them inside separate subdirectories of the Virtuoso database directory (e.g. %VIRTUOSO_HOME%\database\dirty and %VIRTUOSO_HOME%\database\clean).

5]

Create a new service for each data space - the dirty data space (called e.g. dirtydbserv) and the clean data space (called e.g. cleandbserv). The rights of an administrator are needed to proceed this step.

cd %VIRTUOSO_HOME%\database\dirty
virtuoso-t +service create +instance dirtydbserv +configfile virtuoso.ini-dirty

cd %VIRTUOSO_HOME%\database\clean
virtuoso-t +service create +instance cleandbserv +configfile virtuoso.ini-clean

6]

Start the created services.

virtuoso-t -I dirtydbserv +service start
virtuoso-t -I cleandbserv +service start

7]

Using the isql utility, process all SQL scripts located in the initial_db_import directory to import the initial database schema and data.

Note that the scripts located in the clean_db subdirectory (and in the nested relational_db subdirectory) are to be run on the clean database, e.g. using the following command:

isql -S 1111

Script files located in the dirty_db subdirectory are to be run on the dirty database, e.g. using the following command:

isql -S 1112

8]

Your Virtuoso installation is successfuly configured.

Note that after you have created and started a Virtuoso service, you can stop it (and delete it) using the following commands:

virtuoso-t -I [service-name] +service stop
virtuoso-t +service delete +instance [service-name]

The service-name stands for the name the service was given upon creation, e.g. dirtydbserv or cleandbserv.