# Change Log Sync SQL File

**URL:** <https://forum.liquibase.org/t/change-log-sync-sql-file/1098>\
**Category:** General Discussion\
**Created:** [January 28, 2011, 5:15pm UTC](https://forum.liquibase.org/t/change-log-sync-sql-file/1098 "2011-01-28T17:15:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![alana\_cable](https://avatars.discourse-cdn.com/v4/letter/a/8e7dd6/32.png) [@alana\_cable](https://forum.liquibase.org/u/alana_cable)\
**Post date:** [January 28, 2011, 5:15pm UTC](https://forum.liquibase.org/t/change-log-sync-sql-file/1098/1 "2011-01-28T17:15:00Z")

</div>

Hi,

I have a customer that requires sql scripts in order to update the database.&nbsp; We have no access to this database.&nbsp; I need to upgrade the the schema on the db.&nbsp; Currently the schema is not managed by liquibase.&nbsp; I have two change log files, one representing the current state of their database, and one representing the upgrades.&nbsp; I would like to generate a change log sync sql file of the first change log.&nbsp; Whenever I run it through liquibase, it generates a sql file that contains all the table, indexes, etc creation, instead of just the checksum.

The only work around I can think of is to actually create the schema here and then run the change log sync.&nbsp; That seems a bit kludgey though.&nbsp; Any idea’s on how I can just generate the change log sync sql file when I do not have access to the database?

Thanks,  
Alana

&nbsp;

---

<div class="post-metadata">

**Author:** ![alana\_cable](https://avatars.discourse-cdn.com/v4/letter/a/8e7dd6/32.png) [@alana\_cable](https://forum.liquibase.org/u/alana_cable)\
**Post date:** [January 28, 2011, 5:15pm UTC](https://forum.liquibase.org/t/change-log-sync-sql-file/1098/2 "2011-01-28T17:15:00Z")

</div>

Even creating the previous schema is a no go.&nbsp; ☹

I create the previous schema.&nbsp; I then run Liquibase using changeLogSync with output to a file.&nbsp;  
First it outputs the checksums for the previous version of the schema.&nbsp; Then it generates the sql to create the previous schema.  
Finally it gives me the sql to create the new version schema.&nbsp; All I would expect it to do is generate the sql for checksum inserts on the previous schema then give me the sql for the new version of the schema.

Alana

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [January 28, 2011, 5:15pm UTC](https://forum.liquibase.org/t/change-log-sync-sql-file/1098/3 "2011-01-28T17:15:00Z")

</div>

What version of liquibase are you using?&nbsp; Having the schema there should not matter since changeLogSync does not do a database diff at all, it just looks for changes in the changeSet not listed in the databasechangelog table.

Nathan
