# Automating deployment of parallel multitenant schemas

**URL:** <https://forum.liquibase.org/t/automating-deployment-of-parallel-multitenant-schemas/2833>\
**Category:** General Discussion\
**Created:** [January 9, 2014, 3:16am UTC](https://forum.liquibase.org/t/automating-deployment-of-parallel-multitenant-schemas/2833 "2014-01-09T03:16:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![grw](https://avatars.discourse-cdn.com/v4/letter/g/ed8c4c/32.png) [@grw](https://forum.liquibase.org/u/grw)\
**Post date:** [January 9, 2014, 3:16am UTC](https://forum.liquibase.org/t/automating-deployment-of-parallel-multitenant-schemas/2833/1 "2014-01-09T03:16:00Z")

</div>

Hi!  
  
Say I have a system where each tenant has its own schema, and all those schemas contain identical table structures (and views, indexes, triggers etc).&nbsp;&nbsp; (There are also are a handful of other schemas that are different which are used across all tenants.)  
  
I’d like to be able, during a command-line liquibase deployment to loop through all the tenant schema-names and apply a generic-tenant changeset to each of their schemas in turn.&nbsp;   
  
It seems like I could in theory do some shell scripting to wrap around multiple calls to Liquibase to do that (with each tenant’s schema then containing its own databasechangelog; I have no problem with that) with different properties files or command-line arguments per tenant, and the wrapper shell script fetching the tenant/schema-name list and doing the looping calling Liquibase.&nbsp;&nbsp;   
  
But before I go down that route, is there some more native Liquibase way to do looping or specify a group of schema I would like to apply a XML changelog file to each of a specified set of schemas (with separate databasechangelogs then appearing in each schema)?&nbsp;   
  
(I know about CORE-1472, but I don’t know enough Java to see how to get it to address my use case and I’m not sure it applies anyway.) Thanks!

---

<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 9, 2014, 3:16am UTC](https://forum.liquibase.org/t/automating-deployment-of-parallel-multitenant-schemas/2833/2 "2014-01-09T03:16:00Z")

</div>

Nathan

---

<div class="post-metadata">

**Author:** ![un1388784522461r70id](https://avatars.discourse-cdn.com/v4/letter/u/65b543/32.png) [@un1388784522461r70id](https://forum.liquibase.org/u/un1388784522461r70id)\
**Post date:** [January 9, 2014, 3:16am UTC](https://forum.liquibase.org/t/automating-deployment-of-parallel-multitenant-schemas/2833/3 "2014-01-09T03:16:00Z")

</div>

Thanks much Nathan. Appreciate it!