title: Import data on HDFS to SQL Server or export data on HDFS to SQL Server
body: <p>I had been trying to figure out on which is the best approach for porting data from HDFS to SQL Server.</p>
  
  <ul>
  <li>Do I import data from Cloudera Hadoop using sqoop Hadoop Connector for SQL Server 2008 R2 or </li>
  <li>Do I export data from Cloudera Hadoop using sqoop into SQL Server</li>
  </ul>
  
  <p>I am sure that both are possible based on the bunch of links I read through</p>
  
  <ul>
  <li><a href="http://www.cloudera.com/blog/2011/10/apache-sqoop-overview/" rel="nofollow">http://www.cloudera.com/blog/2011/10/apache-sqoop-overview/</a></li>
  <li><a href="http://www.microsoft.com/en-in/download/details.aspx?id=27584" rel="nofollow">http://www.microsoft.com/en-in/download/details.aspx?id=27584</a></li>
  </ul>
  
  <p>But when I am looking for possible issues  that could rise at level of configuration and maintenance I don't have proper answers. </p>
  
  <p>I strongly feel that I should go for import, but I am not comfortable in troubleshooting and maintaining the issues that could come up every now and then.</p>
  
  <p>Can someone share their thoughts on what could be the best?</p>