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
Where 092011 Photography
is the folder containing the XML data of https://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...
Provider:
System.Data.SqlClient
I don't think I ever configured MS SQL server, so I'd probably have to do that.
app
,script
, andlibrary
tags.