title: Testing Unique constraints
body: <p>I am not sure how to proceed to test my unique constraints in my database.
  I'm using NHibernate.</p>
  
  <p>I want to check if a unique constraint I put in my table is working...or is better to said I want to be sure that I put a unique constraint on a specific column in a database.</p>
  
  <p>I can easily write the integration test to check if the unique constraint is working on a database (I save two entities with the same value on the specific column and it must throw the exception).
  But my question is:
  because I can't launch the integration test on database production but only in my database test, how can i be sure that the integration tests work also in the production database? which is the best practice?</p>