# Getting rollout and rollback script separately for each file in changelog xml

**URL:** <https://forum.liquibase.org/t/getting-rollout-and-rollback-script-separately-for-each-file-in-changelog-xml/5738>\
**Category:** General Discussion\
**Created:** [July 28, 2021, 6:08am UTC](https://forum.liquibase.org/t/getting-rollout-and-rollback-script-separately-for-each-file-in-changelog-xml/5738 "2021-07-28T06:08:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![KapilGonjari](https://avatars.discourse-cdn.com/v4/letter/k/ba8739/32.png) [@KapilGonjari](https://forum.liquibase.org/u/KapilGonjari)\
**Post date:** [July 28, 2021, 6:08am UTC](https://forum.liquibase.org/t/getting-rollout-and-rollback-script-separately-for-each-file-in-changelog-xml/5738/1 "2021-07-28T06:08:12Z")

</div>

Hi All,

How i can get rollout and rollback script separately for each sql file in changelog xml ?

As of now if i run UpdateSQL or FutureRollbackSQL commands i get the consolidated list of rollout and rollback scripts for all sql files in changelog xml combined.

---

<div class="post-metadata">

**Author:** ![rakhi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/rakhi/32/288_2.png) [@rakhi](https://forum.liquibase.org/u/rakhi)\
**Post date:** [July 28, 2021, 12:26pm UTC](https://forum.liquibase.org/t/getting-rollout-and-rollback-script-separately-for-each-file-in-changelog-xml/5738/2 "2021-07-28T12:26:03Z")

</div>

Hey!

I think as we are passing `changelog.xml` with entries of all SQL files as input, `updateSQL` will also generate the output for every SQL file provided in input. I don’t think we would be able to get or write rollback/rollout queries in corresponding SQL files.

Thanks!  
Rakhi Agrawal

---

<div class="post-metadata">

**Author:** ![KapilGonjari](https://avatars.discourse-cdn.com/v4/letter/k/ba8739/32.png) [@KapilGonjari](https://forum.liquibase.org/u/KapilGonjari)\
**Post date:** [July 30, 2021, 6:00am UTC](https://forum.liquibase.org/t/getting-rollout-and-rollback-script-separately-for-each-file-in-changelog-xml/5738/3 "2021-07-30T06:00:26Z")

</div>

@rakhi - Thanks. If any other users also needs to have this as feature. Can we have it?

something like : Pass some parameter in liquibase command which will generate separate rollback and rollout scipts for each file in changelog xml.

---

<div class="post-metadata">

**Author:** ![rakhi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/rakhi/32/288_2.png) [@rakhi](https://forum.liquibase.org/u/rakhi)\
**Post date:** [August 10, 2021, 11:24am UTC](https://forum.liquibase.org/t/getting-rollout-and-rollback-script-separately-for-each-file-in-changelog-xml/5738/4 "2021-08-10T11:24:30Z")

</div>

Definitely. Having an enhancement is always a benefit for any product. May be try posting it on Liquibase Git. Hopefully you would get the best response for your enhancement there.