Many of the PATSTAT Raw Data users work on MySQL.
Recently I was in contact with Simone Mainardi (http://www.simonemainardi.com/), who created a handy tool to upload the PATSTAT Raw Data files into MySQL. Simone is happy to share his effort with the community and recently upgraded it to be compatible with the current PATSTAT 2015 Autumn edition.
The tool is called load_patstat and can be accessed via GitHub: https://github.com/simonemainardi/load_patstat.
In other recent posts you can also find more import scripts for MySQL as well as for Postgresql. I applaud and thank all of them for their contribution..
Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
2 posts • Page 1 of 1