Installing the national PISA databases

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 databases corresponding with each one of the countries that interest you. 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:

In the dialog that opens, select the Device option:

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

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:

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.

Following are the links to each one of the national databases:

Albania

Download PISA Albania database
Download PISA Albania database (SQL Server Express)

Argentina

Download PISA Argentina database
Download PISA Argentina database (SQL Server Express)

Australia

Download PISA Australia database
Download PISA Australia database (SQL Server Express)

Austria

Download PISA Austria database
Download PISA Austria database (SQL Server Express)

Azerbaijan

Download PISA Azerbaijan database
Download PISA Azerbaijan database (SQL Server Express)

Belgium

Download PISA Belgium database
Download PISA Belgium database (SQL Server Express)

Brazil

Download PISA Brazil database
Download PISA Brazil database (SQL Server Express)

Bulgaria

Download PISA Bulgaria database
Download PISA Bulgaria database (SQL Server Express)

Canada

Download PISA Canada database
Download PISA Canada database (SQL Server Express)

Chile

Download PISA Chile database
Download PISA Chile database (SQL Server Express)

Chinese Taipei

Download PISA Chinese Taipei database
Download PISA Chinese Taipei database (SQL Server Express)

Colombia

Download PISA Colombia database
Download PISA Colombia database (SQL Server Express)

Connecticut (USA)

Download PISA Connecticut (USA) database
Download PISA Connecticut (USA) database (SQL Server Express)

Costa Rica

Download PISA Costa Rica database
Download PISA Costa Rica database (SQL Server Express)

Croatia

Download PISA Croatia database
Download PISA Croatia database (SQL Server Express)

Czech Republic

Download PISA Czech Republic dtatabase
Download PISA Czech Republic database (SQL Server Express)

Denmark

Download PISA Denmark database
Download PISA Denmark database (SQL Server Express)

Estonia

Download PISA Estonia database
Download PISA Estonia database (SQL Server Express)

Finland

Download PISA Finland database
Download PISA Finland database (SQL Server Express)

Florida (USA)

Download PISA Florida (USA) database
Download PISA Florida (USA) database (SQL Server Express)

France

Download PISA France database
Download PISA France database (SQL Server Express)

Georgia

Download PISA Georgia database
Download PISA Georgia database (SQL Server Express)

Germany

Download PISA Germany database
Download PISA Germany database (SQL Server Express)

Greece

Download PISA Greece database
Download PISA Greece database (SQL Server Express)

Himachal Pradesh-India

Download PISA Himachal Pradesh-India database
Download PISA Himachal Pradesh-India database (SQL Server Express)

Hong Kong (China)

Download PISA Hong Kong (China) database
Download PISA Hong Kong (China) database (SQL Server Express)

Hungary

Download PISA Hungary database
Download PISA Hungary database (SQL Server Express)

Iceland

Download PISA Iceland database
Download PISA Iceland database (SQL Server Express)

Indonesia

Download PISA Indonesia database
Download PISA Indonesia database (SQL Server Express)

Ireland

Download PISA Ireland database
Download PISA Ireland database (SQL Server Express)

Israel

Download PISA Israel database
Download PISA Israel database (SQL Server Express)

Italy

Download PISA Italy database
Download PISA Italy database (SQL Server Express)

Japan

Download PISA Japan database
Download PISA Japan database (SQL Server Express)

Jordan

Download PISA Jordan database
Download PISA Jordan database (SQL Server Express)

Kazakhstan

Download PISA Kazakhstan database
Download PISA Kazakhstan database (SQL Server Express)

Korea

Download PISA Korea database
Download PISA Korea database (SQL Server Express)

Kyrgyzstan

Download PISA Kyrgyzstan database
Download PISA Kyrgyzstan database (SQL Server Express)

Latvia

Download PISA Latvia database
Download PISA Latvia database (SQL Server Express)

Liechtenstein

Download PISA Liechtenstein database
Download PISA Liechtenstein database (SQL Server Express)

Lithuania

Download PISA Lithuania database
Download PISA Lithuania database (SQL Server Express)

Luxembourg

Download PISA Luxembourg database
Download PISA Luxembourg database (SQL Server Express)

Macao (China)

Download PISA Macao (China) database
Download PISA Macao (China) database (SQL Server Express)

Macedonia

Download PISA Macedonia database
Download PISA Macedonia database (SQL Server Express)

Malaysia

Download PISA Malaysia database
Download PISA Malaysia database (SQL Server Express)

Malta

Download PISA Malta database
Download PISA Malta database (SQL Server Express)

Massachusetts (USA)

Download PISA Massachusetts (USA) database
Download PISA Massachusetts (USA) database (SQL Server Express)

Mauritius

Download PISA Mauritius database
Download PISA Mauritius database (SQL Server Express)

Mexico

Download PISA Mexico database
Download PISA Mexico database (SQL Server Express)

Miranda-Venezuela

Download PISA Miranda-Venezuela database
Download PISA Miranda-Venezuela database (SQL Server Express)

Montenegro

Download PISA Montenegro database
Download PISA Montenegro database (SQL Server Express)

Netherlands

Download PISA Netherlands database
Download PISA Netherlands database (SQL Server Express)

New Zealand

Download PISA New Zealand database
Download PISA New Zealand database (SQL Server Express)

Norway

Download PISA Norway database
Download PISA Norway database (SQL Server Express)

Panama

Download PISA Panama database
Download PISA Panama database (SQL Server Express)

Perm(Russian Federation)

Download PISA Perm(Russian Federation) database
Download PISA Perm(Russian Federation) database (SQL Server Express)

Peru

Download PISA Peru database
Download PISA Peru database (SQL Server Express)

Poland

Download PISA Poland database
Download PISA Poland database (SQL Server Express)

Portugal

Download PISA Portugal database
Download PISA Portugal database (SQL Server Express)

Qatar

Download PISA Qatar database
Download PISA Qatar database (SQL Server Express)

Republic of Moldova

Download PISA Republic of Moldova database
Download PISA Republic of Moldova database (SQL Server Express)

Romania

Download PISA Romania database
Download PISA Romania database (SQL Server Express)

Russian Federation

Download PISA Russian Federation database
Download PISA Russian Federation database (SQL Server Express)

Serbia

Download PISA Serbia database
Download PISA Serbia database (SQL Server Express)

Shanghai-China

Download PISA Shanghai-China database
Download PISA Shanghai-China database (SQL Server Express)

Singapore

Download PISA Singapore database
Download PISA Singapore database (SQL Server Express)

Slovak Republic

Download PISA Slovak Republic database
Download PISA Slovak Republic database (SQL Server Express)

Slovenia

Download PISA Slovenia database
Download PISA Slovenia database (SQL Server Express)

Spain

Download PISA Spain database
Download PISA Spain database (SQL Server Express)

Sweden

Download PISA Sweden database
Download PISA Sweden database (SQL Server Express)

Switzerland

Download PISA Switzerland database
Download PISA Switzerland database (SQL Server Express)

Tamil Nadu-India

Download PISA Tamil Nadu-India database
Download PISA Tamil Nadu-India database (SQL Server Express)

Thailand

Download PISA Thailand database
Download PISA Thailand database (SQL Server Express)

Trinidad and Tobago

Download PISA Trinidad and Tobago database
Download PISA Trinidad and Tobago database (SQL Server Express)

Tunisia

Download PISA Tunisia database
Download PISA Tunisia database (SQL Server Express)

Turkey

Download PISA Turkey database
Download PISA Turkey database (SQL Server Express)

United Arab Emirates

Download PISA United Arab Emirates database
Download PISA United Arab Emirates database (SQL Server Express)

United Kingdom

Download PISA United Kingdom database
Download PISA United Kingdom database (SQL Server Express)

United States

Download PISA United States database
Download PISA United States database (SQL Server Express)

Uruguay

Download PISA Uruguay database
Download PISA Uruguay database (SQL Server Express)

Viet Nam

Download PISA Viet Nam database
Download PISA Viet Nam database (SQL Server Express)

Yugoslavia

Download PISA Yugoslavia database
Download PISA Yugoslavia database (SQL Server Express)