# Can't get rollbackSqlFile to work with formatted sql

**URL:** <https://forum.liquibase.org/t/cant-get-rollbacksqlfile-to-work-with-formatted-sql/9339>\
**Category:** Liquibase Development\
**Created:** [April 29, 2024, 9:27pm UTC](https://forum.liquibase.org/t/cant-get-rollbacksqlfile-to-work-with-formatted-sql/9339 "2024-04-29T21:27:48Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![bryntreacy](https://avatars.discourse-cdn.com/v4/letter/b/958977/32.png) [@bryntreacy](https://forum.liquibase.org/u/bryntreacy)\
**Post date:** [April 29, 2024, 9:27pm UTC](https://forum.liquibase.org/t/cant-get-rollbacksqlfile-to-work-with-formatted-sql/9339/1 "2024-04-29T21:27:48Z")

</div>

The documentation says the “–rollbackSQLFile” command can be used in a formatted sql file to point to an external file to execute. Using v 4.27.0 I keep seeing a “Liquibase does not support automatic rollback creation” error, which I’m assuming means it can’t find the file. I’ve tried various combos to get this to work, but I must be missing something. Any ideas? Thanks!

---

<div class="post-metadata">

**Author:** ![daryldoak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/daryldoak/32/764_2.png) [@daryldoak](https://forum.liquibase.org/u/daryldoak)\
**Post date:** [April 29, 2024, 9:42pm UTC](https://forum.liquibase.org/t/cant-get-rollbacksqlfile-to-work-with-formatted-sql/9339/2 "2024-04-29T21:42:58Z")

</div>

According to this page:

> **[Example Changelogs: SQL Format](https://docs.liquibase.com/concepts/changelogs/sql-format.html)**
>
> Reference information for SQL changelogs. Liquibase supports SQL as a format for storing your changelog files.

rollbackSQLFile requires a Pro license key.

---

<div class="post-metadata">

**Author:** ![bryntreacy](https://avatars.discourse-cdn.com/v4/letter/b/958977/32.png) [@bryntreacy](https://forum.liquibase.org/u/bryntreacy)\
**Post date:** [April 29, 2024, 10:47pm UTC](https://forum.liquibase.org/t/cant-get-rollbacksqlfile-to-work-with-formatted-sql/9339/3 "2024-04-29T22:47:46Z")

</div>

Thanks, @daryldoak. Yes, I have a PRO key in my license.properties file, forgot to include that info. Let me know if you have any other suggestions!

---

<div class="post-metadata">

**Author:** ![bryntreacy](https://avatars.discourse-cdn.com/v4/letter/b/958977/32.png) [@bryntreacy](https://forum.liquibase.org/u/bryntreacy)\
**Post date:** [April 29, 2024, 11:36pm UTC](https://forum.liquibase.org/t/cant-get-rollbacksqlfile-to-work-with-formatted-sql/9339/4 "2024-04-29T23:36:18Z")

</div>

Figured out the issue. It wasn’t clear to me after reading the docs, but “path” is required in order to get this to work. Example: --rollbackSqlFile path:rollback.sql

---

<div class="post-metadata">

**Author:** ![wwillard](https://avatars.discourse-cdn.com/v4/letter/w/8e8cbc/32.png) [@wwillard](https://forum.liquibase.org/u/wwillard)\
**Post date:** [May 1, 2024, 2:01pm UTC](https://forum.liquibase.org/t/cant-get-rollbacksqlfile-to-work-with-formatted-sql/9339/5 "2024-05-01T14:01:27Z")

</div>

I have submitted an issue to the docs team to get that corrected.

Thanks,  
Wesley