title: Hibernate/JPA SQLServer Primary Key Autoincrement
body: <p>I am porting my database from MySQL to SQLServer. I am having problem when during startup the tables are created and i get syntax error. As below</p>
  
  <p>SEVERE: Unsuccessful: create table ANSWER (AID bigint not null auto_increment, ANS varchar(255), NUMBER integer, QID bigint, primary key (AID)) type=InnoDB
  Jan 12, 2011 1:25:28 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
  SEVERE: <strong>Incorrect syntax near 'auto_increment'.</strong></p>
  
  <p>I tried to run the above SQL directly in MsSQLServer and got the syntax error regarding auto increment.</p>
  
  <p>The code used to work perfectly fine in MYSql.</p>
  
  <pre><code>@Entity 
  @Table(name = "ANSWER") 
  public class Answer implements Identifiable&lt;Long&gt;, Serializable, Comparable&lt;Answer&gt; {
  
      @Id
      @Column(name = "AID")
      @GeneratedValue(strategy = GenerationType.AUTO)
      private Long id;
  </code></pre>
  
  <p>Thank you.</p>