===== rollbackDatabase Ant Task =====

Rolls back database changes.  See [[rollback]] page for more information.


==== Sample ====

<code xml>
<target name="rollback-database" depends="prepare">
    <fail unless="db.changelog.file">db.changelog.files not set</fail>
    <fail unless="database.url">database.url not set</fail>

    <fail unless="database.username">database.username not set</fail>
    <fail unless="database.password">database.password not set</fail>

    <taskdef resource="migratortasks.properties">
        <classpath refid="classpath"/>
    </taskdef>

    <rollbackDatabase
            changeLogFile="${db.changelog.file}"
            driver="${database.driver}"
            url="${database.url}"
            username="${database.username}"
            password="${database.password}"
            classpathref="classpath"
            rollbackTag="release1.2"
            >
    </rollbackDatabase>
</target>
</code>


==== Available Parameters ====

^ changeLogFile  | The change log file to run  | 
^ driver  | The name of the database driver to connect with  | 
^ url  | The database URL  | 
^ username  | The database username to connect with  | 
^ password  | The password to use when connecting to the database  | 
^ defaultSchemaName  | Schema to use as a default for managed database objects and for LiquiBase control tables  |
^ outputFile  | Outputs SQL to file rather than execute it directly  |
^ classpathref  | A reference to the classpath that contains the database driver, liquibase.jar, and the changelog.xml files  | 
^ rollbackTag  | Tag to roll back to  | 
^ rollbackDate  | Date to roll back to  | 
^ rollbackCount  | Number of changeSets to roll back  | 
^ contexts  | A comma separated list of [[contexts]] to roll back. If not specified, all contexts are rolled back.  | 

==== Available Sub Tags ====
^ changeLogProperty  | Sets a [[changelog parameters]] set //Since LiquiBase 1.7// | 

=== Available <changeLogProperty> Parameters ===
^ name  | The name of the property to set  | 
^ value  | The value of the property to set  |