Are there any scripts available to import the data dump into databases other then SQL Server? I don't have an SQL Server license, and the data dump will probably out grow the SQL Server Express 4 gig limit if it hasn't already.
What is meta?
- Any Stack Exchange user can ask a question
- The community provides support, votes on ideas, and reports bugs
- Your voice helps shape the way Stack Exchange operates
I've created a script that uses Groovy and Hibernate to at least in theory, import the data dump into any database Hibernate supports.
I have gotten it to work with MySQL and PostgreSQL but it doesn’t work on HSQLDB, those are the only three I’ve tested it on. The code isn’t optimized and takes about an hour to import all five files, but I plan on improving it when I get a chance. The Git repository can be found on Github, I hope it's useful to others.
Here is a windows application that will import to MySQL, MS SQL Server and SQLite:
There's been an SQLite version of the data dump for past versions... I'll dig up a couple of URLs.
Here's the June dump - I don't believe July and August are available, unfortunately.
I have some code to convert it into Protocol Buffer files, but that's probably a bit of a niche market :)
There's also the Data Dump Sandbox if you're happy to use a web interface :)