I am trying to import the September 2011 data dump into MS SQL using Stack Overflow Data Dump Import. I am a novice with SQL server projects and would really appreciate your help and suggestions to get around with this.
After creating an empty SQL server project named Database1 in Visual Studio, I typed the following in the application's GUI:
Source: C:\OSU\092011 Photography
092011 Photography is the folder containing the XML data of http://photo.stackexchange.com/.
Target: Data Source="C:\Users\Nira\Documents\Visual Studio 2013\Projects";Initial Catalog=Database1;Integrated Security=True
I am not sure what these values are supposed to be...
I don't think I ever configured MS SQL server, so I'd probably have to do that.