title: migrating TFS data to SQL Server 2008 for reporting
body: <p>We are developing a reporting sytem which actually consolidates project related data (Bugs, Issues, Testcases) from different systems like TFS,svn etc. so that managerial guys can diffrent kind of reports of any project.</p>
  
  <p>For this purpose we want TFS data to move to our SQL Server database because, as per our understanding we can't access TFS database directly in the production environment.</p>
  
  <p>Can we use the TFS api to Transfer the data or is any other efficient method available?</p>
  
  <p>please suggest.</p>