# Ability to run updateSQL without access to a database

**URL:** <https://forum.liquibase.org/t/ability-to-run-updatesql-without-access-to-a-database/1128>\
**Category:** General Discussion\
**Created:** [February 23, 2011, 12:53am UTC](https://forum.liquibase.org/t/ability-to-run-updatesql-without-access-to-a-database/1128 "2011-02-23T00:53:00Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![emszpak](https://avatars.discourse-cdn.com/v4/letter/e/eb8c5e/32.png) [@emszpak](https://forum.liquibase.org/u/emszpak)\
**Post date:** [February 23, 2011, 12:53am UTC](https://forum.liquibase.org/t/ability-to-run-updatesql-without-access-to-a-database/1128/1 "2011-02-23T00:53:00Z")

</div>

Hi,  
  
  
Is it possible to generate SQL update scripts without psyhical access to a database? Just tell Liquibase which version is applied on destination server and which new changes should be used.  
Currently I have to have local DB with the same structure to run updateSQL on it.  
  
  
Regards  
Marcin

---

<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:** [February 23, 2011, 12:53am UTC](https://forum.liquibase.org/t/ability-to-run-updatesql-without-access-to-a-database/1128/2 "2011-02-23T00:53:00Z")

</div>

Currently you do need a local database to connect to. &nbsp;Partly because liquibase needs a databasechangelog table to see what changes have been ran, and partly because we have not implemented a “just list the database type+version” feature yet.

Nathan

---

<div class="post-metadata">

**Author:** ![emszpak](https://avatars.discourse-cdn.com/v4/letter/e/eb8c5e/32.png) [@emszpak](https://forum.liquibase.org/u/emszpak)\
**Post date:** [February 23, 2011, 12:53am UTC](https://forum.liquibase.org/t/ability-to-run-updatesql-without-access-to-a-database/1128/3 "2011-02-23T00:53:00Z")

</div>

Thanks for your answer. I assume it is on a roadmap. Is there any issue in an issue tracker which I could track to be get notified when it would be implemented?

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [February 23, 2011, 12:53am UTC](https://forum.liquibase.org/t/ability-to-run-updatesql-without-access-to-a-database/1128/4 "2011-02-23T00:53:00Z")

</div>

Thanks for your information.  
  
Marcin

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [February 23, 2011, 12:53am UTC](https://forum.liquibase.org/t/ability-to-run-updatesql-without-access-to-a-database/1128/5 "2011-02-23T00:53:00Z")

</div>

This issue was also discussed here:   
[http://liquibase.org/forum/index.php?topic=666.msg2419#new](http://liquibase.org/forum/index.php?topic=666.msg2419#new)

Its really something a lot of people would like to see. Just a plain set of properties: database, version, applied changeset ids.

I stay tuned.

---

<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:** [February 23, 2011, 12:53am UTC](https://forum.liquibase.org/t/ability-to-run-updatesql-without-access-to-a-database/1128/6 "2011-02-23T00:53:00Z")

</div>

I added&nbsp;[http://liquibase.jira.com/browse/CORE-883](http://liquibase.jira.com/browse/CORE-883)&nbsp;give something for people to vote for/watch

Nathan