# How to generate a SQL file with rollbackSQL with offline mode

**URL:** <https://forum.liquibase.org/t/how-to-generate-a-sql-file-with-rollbacksql-with-offline-mode/3283>\
**Category:** General Discussion\
**Created:** [September 11, 2015, 9:55pm UTC](https://forum.liquibase.org/t/how-to-generate-a-sql-file-with-rollbacksql-with-offline-mode/3283 "2015-09-11T21:55:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![CarlosCruz](https://avatars.discourse-cdn.com/v4/letter/c/53a042/32.png) [@CarlosCruz](https://forum.liquibase.org/u/CarlosCruz)\
**Post date:** [September 11, 2015, 9:55pm UTC](https://forum.liquibase.org/t/how-to-generate-a-sql-file-with-rollbacksql-with-offline-mode/3283/1 "2015-09-11T21:55:00Z")

</div>

Hi all

  
  

That is the question. I want to generate a file with the sql rollback sentences from a changesets file, but I want to do it without active connection, I mean, offline.

  

So I tried with this command:

  

java -jar liquibase.jar --url="offline:postgresql?changeLogFile=changelogfile.csv" --changeLogFile=MyChangesets.xml rollbackSql MY\_TAG\_DATABASE \> "/path/to/output/file.sql"
But I got this error: 

  

Unexpected error running Liquibase: Could not find tag 'MY\_TAG\_DATABASE' in the database

  

I am pretty sure that the tagDatabase 'MY\_TAG\_DATABASE' is in MyChangesets.xml file, is like:

   

   

 

```
  <changeSet id="MY_CHANGESET_XXX" author="author">

```

 

   

   

, but, as I said, there isn't database because I am working in offline mode.

   

How can I generate the rollback sql file with offline database?

   

Thanks a lot !!