Before I go about doing this myself, I wonder, has anyone written a script or program that can efficiently and quickly load up the the SO data into SQL Server.
I tried the script here but it completely took out my machine.
Im thinking either some c# script that streams through the xml file forward only and uses bulk inserter should do the trick.
Otherwise I'm considering just converting the sqlite dump _nobody created to sql server should be fairly fast.
Any other ideas or scripts to do this out there? Perhaps a compressed sql server backup torrent?
Update I created a very fast sql server importer which lives on github.
Related What interesting stats can I obtain from the Stack Overflow data-dump?