Installing the shared PISA database

This database must be installed in Microsoft SQL Server You can use any SQL Server edition, but the Enterprise Edition is recommended, as it allows partitioning the tables. I have built the database with the 2012 version of the server. In this link, you can download SQL Server 2012 Express Edition

First, you must download the copy of the database PISAComun.bak from this link. Once downloaded, proceed to install it from SQL Server Management Studio. Click with the right mouse button on the Databases folder of the local database server and select the option Restore Database:

Restore database option in SQL Server — The restore database option

In the dialog that opens, select the Device option:

Select the restore from device option — Select restore from device

Press the ... button, at the right of the text box, and then find the downloaded PISAComun.bak file by pressing the Add button.

Add the downloaded .bak file — Select de downloaded .bak file

Once selected the file, press the OK button. If you want to select a different location to store the database instead of the selected by default, select the Files option to indicate where to create both the database files and the Log register:

Change the target directory of database files — Change the target directory of the database files if you want

Mark the Relocate all files to folder check box and then select the new folders by pressing the ... buttons located at the right of the Data file folder and Log file folder text boxes. If you have multiple disks, is recommendable to separate thee database and log files in different disk units, in order to optimize the data access.

Once do so, you can press the OK button and the database will be installed on the server.