Hi Users
I am an early year PhD student and part of my thesis will use the PATSTAT dataset. I have bought and downloaded the 2019 Global Autumn dataset. As a beginner in MS SQL, I have installed MS SQL server management studio. But, I am having a hard time importing all the data files in the studio. I have tried to use "create database script" without any avail. I have searched all over the internet but did not find any hands-on document or video to use PATSTAT global.
I know I am a noob. I would highly appreciate if you guys can point or direct me any resources that I can use.
Thanks
Asraf
Seeking help on using PATSTAT global 2019
-
- Posts: 426
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: Seeking help on using PATSTAT global 2019
Hello Asraf,
The scripts provided in the documentation for creating the data base and the tables are only provided as an example on how it can be done.
You have to adapt the scipts to your specific environment and data base settings, or create your own set.
Just a small example: the first lines of the script create space and files on the D: drive in the folder mssql_dbs\patstat2019b. If the D: drive or the folder \mssql_dbs\patstat2019b\ does not exist, the script will fail.
At the EPO for example, we use IP addresses to refer to the place where the database should be created, it would be something like:
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test_dat', FILENAME = N'\\175.21.1.151\WorkData\patstat2019bdat.mdf' , SIZE = 20MB , MAXSIZE = UNLIMITED , FILEGROWTH = 51200KB )....
So it is nearly 100% sure that you have adapt the scripts to your server and that is something the EPO can not support users with because every server installation (or server platform) has it own environment dependant settings. The most pragmatic solution is to find somebody (at the university ?) who can help you to adapt the scripts.
The scripts provided in the documentation for creating the data base and the tables are only provided as an example on how it can be done.
Code: Select all
CREATE DATABASE [patstat2019b] ON PRIMARY
( NAME = N'patstat2019b_dat', FILENAME = N'D:\mssql_dbs\patstat2019b\patstat2019bdat.mdf' , SIZE = 200000MB , MAXSIZE = UNLIMITED , FILEGROWTH = 51200KB )
LOG ON
( NAME = N'patstat2019b_log', FILENAME = N'D:\mssql_dbs\patstat2019b\patstat2019blog.ldf' , SIZE = 1000MB , MAXSIZE = UNLIMITED , FILEGROWTH = 15360KB )
COLLATE SQL_Latin1_General_CP1_CI_AS
GO
Just a small example: the first lines of the script create space and files on the D: drive in the folder mssql_dbs\patstat2019b. If the D: drive or the folder \mssql_dbs\patstat2019b\ does not exist, the script will fail.
At the EPO for example, we use IP addresses to refer to the place where the database should be created, it would be something like:
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test_dat', FILENAME = N'\\175.21.1.151\WorkData\patstat2019bdat.mdf' , SIZE = 20MB , MAXSIZE = UNLIMITED , FILEGROWTH = 51200KB )....
So it is nearly 100% sure that you have adapt the scripts to your server and that is something the EPO can not support users with because every server installation (or server platform) has it own environment dependant settings. The most pragmatic solution is to find somebody (at the university ?) who can help you to adapt the scripts.
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org
EPO - Vienna
patstat @ epo.org