This website uses Google cookies to provide its services and analyze your traffic. Your IP address and user-agent are shared with Google, along with performance and security metrics, to ensure quality of service, generate usage statistics and detect and address abuses.More information

Ver sitio en español Go to homepage Contact me
sábado, 16 de enero de 2016

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:

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

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

Albania

Albania flag

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

Argentina

Argentina flag

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

Australia

Australia flag

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

Austria

Austria flag

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

Azerbaijan

Azerbaijan flag

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

Belgium

Belgium flag

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

Brazil

Brazil flag

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

Bulgaria

Bulgaria flag

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

Canada

Canada flag

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

Chile

Chile flag

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

Chinese Taipei

Chinese Taipei flag

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

Colombia

Colombia flag

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

Connecticut (USA)

Connecticut (USA) flag

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

Costa Rica

Costa Rica flag

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

Croatia

Croatia flag

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

Czech Republic

Czech Republic Flag

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

Denmark

Denmark flag

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

Estonia

Estonia flag

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

Finland

Finland flag

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

Florida (USA)

Florida (USA) flag

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

France

France flag

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

Georgia

Georgia flag

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

Germany

Germany flag

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

Greece

Greece flag

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

Himachal Pradesh-India

Himachal Pradesh-India flag

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

Hong Kong (China)

Hong Kong (China) flag

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

Hungary

Hungary flag

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

Iceland

Iceland flag

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

Indonesia

Indonesia flag

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

Ireland

Ireland flag

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

Israel

Israel flag

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

Italy

Italy flag

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

Japan

Japan flag

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

Jordan

Jordan flag

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

Kazakhstan

Kazakhstan flag

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

Korea

Korea flag

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

Kyrgyzstan

Kyrgyzstan flag

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

Latvia

Latvia flag

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

Liechtenstein

Liechtenstein flag

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

Lithuania

Lithuania flag

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

Luxembourg

Luxembourg flag

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

Macao (China)

Macao (China) flag

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

Macedonia

Macedonia flag

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

Malaysia

Malaysia flag

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

Malta

Malta flag

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

Massachusetts (USA)

Massachusetts (USA) flag

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

Mauritius

Mauritius flag

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

Mexico

Mexico flag

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

Miranda-Venezuela

Miranda-Venezuela flag

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

Montenegro

Montenegro flag

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

Netherlands

Netherlands flag

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

New Zealand

New Zealand flag

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

Norway

Norway flag

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

Panama

Panama flag

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

Perm(Russian Federation)

Perm(Russian Federation) flag

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

Peru

Peru flag

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

Poland

Poland flag

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

Portugal

Portugal flag

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

Qatar

Qatar flag

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

Republic of Moldova

Republic of Moldova flag

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

Romania

Romania flag

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

Russian Federation

Russian Federation flag

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

Serbia

Serbia flag

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

Shanghai-China

Shanghai-China flag

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

Singapore

Singapore flag

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

Slovak Republic

Slovak Republic flag

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

Slovenia

Slovenia flag

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

Spain

Spain flag

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

Sweden

Sweden flag

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

Switzerland

Switzerland flag

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

Tamil Nadu-India

Tamil Nadu-India flag

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

Thailand

Thailand flag

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

Trinidad and Tobago

Trinidad and Tobago flag

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

Tunisia

Tunisia flag

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

Turkey

Turkey flag

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

United Arab Emirates

United Arab Emirates flag

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

United Kingdom

United Kingdom flag

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

United States

United States flag

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

Uruguay

Uruguay flag

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

Viet Nam

Viet Nam flag

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

Yugoslavia

Yugoslavia flag

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

Comments (0):
* (Your comment will be published after revision)

E-Mail


Name


Web


Message


CAPTCHA
Change the CAPTCHA codeSpeak the CAPTCHA code