Updated Stack Overflow Database Dump Importer v1.4

Stack Overflow Database

The nice folks at Stack Overflow publish their entire data set (data included) in XML format. It’s tons of fun for demos, but you need a way to get it into a relational database.

The Stack Overflow Data Dump Importer (SODDI) makes this point-and-click easy. Just download the latest release, install it, download the XML exports, and you can import it into MySQL, SQLite, or Microsoft SQL Server.

Last week, we sponsored @AndrewBrobston to make a few improvements and release v1.4:

  • Add support for the PostHistory, PostLinks, and Tags tables
  • Enable you to set the Id fields as identities (really useful for the workloads in my training classes)
  • Enable MySQL and SQLite support again (had broken in prior releases)

@BennetElder also added a database connection dialog to make it easier to pick & choose the target database.

Stack Overflow
The place that saves your job

Next steps:

Previous Post
Free Upcoming Webcasts: Query Store, R, AGs, Encryption, Security, and More
Next Post
[Video] Office Hours 2017/11/15 (With Transcriptions)

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.