title: Integration Testing with Flyway
body: <p>I'm using <a href="https://flywaydb.org/" rel="noreferrer">Flyway</a> to handle the database migration. Everything is working fine: the default location of the migration files is:</p>
  
  <pre><code>main/resource/db/migration/V1...
  </code></pre>
  
  <p>I am running integration tests and my setup uses an separate database schema for integration, which I would like to manage with flyway as well.
  The integration tests, though, are located in the <code>test</code> folder (not <code>main</code>). When the Flyway bean executes <code>migrate()</code>, it doesn't find the migration files because they are in the <code>main</code> folder. If I put the migration files in <code>test/resource/db/migration/V1...</code> it works.</p>
  
  <p>I really don't want to have to copy these file into the <code>test</code> resource folder, so I don't have to maintain both. Is there a way to force Flyway to use the same migration files for the integration test as for the normal app?</p>