title: Can I change H2 embedded DB dialect to Sybase?
body: <p>I need to write some test on my project which use Sybase DB. These tests closely related to running some SQL requests. For this purpose we must use myBatis and DBunit approach with h2 embedded DB. But issue is that some Sybase and h2 has a little bit different syntax for same functions.</p>
  
  <p>Example:</p>
  
  <pre><code>    Sybase: CONVERT(data_type, expression [, format_style])
      H2: CONVERT(value, data_type)
  </code></pre>
  
  <p>So as you can see if I will write SQL's based on H2 dialect tests will be passed but code in application which will run it on Sybase will fail for sure.</p>
  
  <p>Questions: </p>
  
  <ol>
  <li>Is there any way how make H2 DB understand Sybase dialect?</li>
  <li>Is there any way how to make SQL's to be compatible on different DB's and this is exactly what I need bcos there is a chance that in future we can move to another DB and rewrite all SQL's will be a very bad and time consuming?</li>
  </ol>