title: Doctrine2 SQL Server Mapping Generation
body: <p>I have a large (100+ tables) SQL Server 2005 database that I would like to start mapping with Doctrine. Right now I've done a manual job of a few tables (no relations yet, just disparate tables), using PHPDOC annotation mapping inside my entities. Manually it works like a charm ... however it really will take ages to get everything mapped out and I'm looking for an easier way.</p>
  
  <p>I looked into ORM Designer, but it doesn't seem to offer imports from a SQL Server database. I also looked at using Doctrine CLI and doing the "reverse engineering" mentioned <a href="http://www.doctrine-project.org/docs/orm/2.0/en/reference/tools.html#reverse-engineering" rel="nofollow">here</a>. Finally tried using <code>orm:convert-mapping --from-database</code> with no luck. It appears the last two are conditional on the fact that the sqlsrv drivers (running on IIS7 here) cause an error on my tables when they have no index: <code>PDOException: The active result for the query contains no fields</code>. </p>
  
  <p>Is it possible that I can load up Doctrine on an Ubuntu machine, and use whatever drivers Linux has to connect to SQL Server 2005 ... then perhaps the orm:convert-mapping feature wouldn't die on me?</p>
  
  <p>Any help would be much appreciated!</p>