# Keycloak Database creation - keycloak-database-update.sql

**URL:** <https://forum.keycloak.org/t/keycloak-database-creation-keycloak-database-update-sql/5543>\
**Category:** Miscellanaeous\
**Tags:** admin-console, authentication, identity-brokering, gatekeeper, oidc\
**Created:** [October 23, 2020, 3:14am UTC](https://forum.keycloak.org/t/keycloak-database-creation-keycloak-database-update-sql/5543 "2020-10-23T03:14:40Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![ssb](https://avatars.discourse-cdn.com/v4/letter/s/eb9ed0/32.png) [@ssb](https://forum.keycloak.org/u/ssb)\
**Post date:** [November 9, 2020, 9:36pm UTC](https://forum.keycloak.org/t/keycloak-database-creation-keycloak-database-update-sql/5543/2 "2020-11-09T21:36:12Z")

</div>

For anyone, who might be looking for the same and wants to execute the script manually, this might be helpful so I decided to post the solution.  
In the **connectionsJpa** , set the below :

1. “ **initializeEmpty** ” to “ **false** ”
2. “ **migrationStrategy** ” to “ **manual** ”
3. “ **migrationExport** ” to the path you want the script to be generated.

---

_[View the full topic](https://forum.keycloak.org/t/keycloak-database-creation-keycloak-database-update-sql/5543)._