title: Flyway location - Point to single sql script
body: <p>I have scripts in folder like this:</p>
  
  <pre><code>D:/dev/DatabaseSetup/oracle/010__script.sql
  D:/dev/DatabaseSetup/oracle/020__script.sql
  D:/dev/DatabaseSetup/oracle/030__script.sql
  D:/dev/DatabaseSetup/oracle/040__script.sql
  D:/dev/DatabaseSetup/oracle/050__script.sql
  </code></pre>
  
  <p>I would like to keep all scripts in same folder, but ignore some of them in migration. To be precise, I would like to include just this scripts</p>
  
  <pre><code>&lt;locations&gt;
      &lt;location&gt;filesystem:oracle/020__script.sql&lt;/location&gt;
      &lt;location&gt;filesystem:oracle/030__script.sql&lt;/location&gt;
      &lt;location&gt;filesystem:oracle/040__script.sql&lt;/location&gt;
  &lt;/locations&gt;
  </code></pre>
  
  <p>Path of <code>pom.xml</code> is <code>D:/dev/DatabaseSetup/oracle/pom.xml</code>.</p>
  
  <p>I read this <a href="https://stackoverflow.com/questions/35205821/ignore-sql-file-for-environments">question </a>, but figured out that I cannot specify single sql script for migration (in accepted answer it is used classpath which points to java package). </p>
  
  <p>Is it even possible? I got following error:</p>
  
  <pre><code>[ERROR] Failed to execute goal org.flywaydb:flyway-maven-plugin:3.2.1:migrate (default-cli) on proje
  ct DatabaseSetup: org.flywaydb.core.api.FlywayException: Unable to scan for SQL migrations in lo
  cation: filesystem:D:/dev/DatabaseSetup/oracle/020__script.sql: Invalid filesystem path:
  D:/dev/DatabaseSetup/oracle/020__script.sql -&gt; [Help 1]
  </code></pre>
  
  <p>When I change <code>&lt;locations&gt;</code> to</p>
  
  <pre><code>&lt;locations&gt;
      &lt;location&gt;filesystem:oracle&lt;/location&gt;
  &lt;/locations&gt;
  </code></pre>
  
  <p>flyway executes all scripts.</p>