title: Java In-memory database with SQL Server support
body: <p>Which of the available in-memory databases has best support for SQL Server specific features?</p>
  
  <p>I've been trying with H2, but had problems for example with escaping column names: in all of our our sql queries we use the (non-standard) [FIELDNAME] instead of "FIELDNAME". This is apparently not supported by H2. There might be also other non-standard features that might be used, so I wonder if anybody knows of a specific database which targets compatibility with SQL Server.</p>
  
  <p>To put this into context I'm using maven and the maven-sql-plugin to create the database before running the tests.</p>
  
  <p>I've been looking at</p>
  
  <ul>
  <li>H2</li>
  <li>HSQL</li>
  <li>Derby</li>
  </ul>
  
  <p>but could not determine which one had best support for SQL Server or if there are others to look at.</p>