# Sequentially uploading scripts in two different schemas

**URL:** <https://forum.liquibase.org/t/sequentially-uploading-scripts-in-two-different-schemas/4960>\
**Category:** General Discussion\
**Created:** [January 13, 2021, 10:35pm UTC](https://forum.liquibase.org/t/sequentially-uploading-scripts-in-two-different-schemas/4960 "2021-01-13T22:35:18Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![praneethvarmab](https://avatars.discourse-cdn.com/v4/letter/p/d2c977/32.png) [@praneethvarmab](https://forum.liquibase.org/u/praneethvarmab)\
**Post date:** [January 13, 2021, 10:35pm UTC](https://forum.liquibase.org/t/sequentially-uploading-scripts-in-two-different-schemas/4960/1 "2021-01-13T22:35:18Z")

</div>

we have two different schemas in oracle db and now we are trying to do a sequential order of the changelogs. For ex =: we have a dependency folder where we author sql files. once the files are completed we want to deploy to the oracle db where the two schemas are present. while deploying we want to run some scripts in schema 1 and then schema2 and then again in schema 1. Is there a way to do it?

---

<div class="post-metadata">

**Author:** ![ronak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/ronak/32/221_2.png) [@ronak](https://forum.liquibase.org/u/ronak)\
**Post date:** [January 22, 2021, 4:45am UTC](https://forum.liquibase.org/t/sequentially-uploading-scripts-in-two-different-schemas/4960/2 "2021-01-22T04:45:05Z")

</div>

Hi @praneethvarmab,

Good question! Liquibase runs scripts in a folder (using the [includeAll](https://docs.liquibase.com/concepts/advanced/includeall.html) tag) in alpha numeric order. So, just order your includes by which folders you want to run alphanumerically, and within those folders make sure your order them alphanumerically.

Make sense?

---

<div class="post-metadata">

**Author:** ![praneethvarmab](https://avatars.discourse-cdn.com/v4/letter/p/d2c977/32.png) [@praneethvarmab](https://forum.liquibase.org/u/praneethvarmab)\
**Post date:** [January 22, 2021, 9:49pm UTC](https://forum.liquibase.org/t/sequentially-uploading-scripts-in-two-different-schemas/4960/3 "2021-01-22T21:49:43Z")

</div>

Thank you for the Answer. Just wanted to confirm. Even if we do it alphanumerically, it will execute all the scripts in that particular folder, but what if I want to do only certain scripts and then do the rest again.

---

<div class="post-metadata">

**Author:** ![ronak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/ronak/32/221_2.png) [@ronak](https://forum.liquibase.org/u/ronak)\
**Post date:** [January 24, 2021, 9:14pm UTC](https://forum.liquibase.org/t/sequentially-uploading-scripts-in-two-different-schemas/4960/4 "2021-01-24T21:14:03Z")

</div>

You can organize the scripts within the folder into sub-folders, that are again organized in alpha sub-folder.

Let’s say I have a folder:  
FolderA  
runfirst.sql  
runsecond.sql  
runatend.sql

I could organize it:

- FolderA
- 
  - FolderA1

- 
  - 
    - runfirst.sql

- 
  - 
    - runsecond.sql

- 
  - FolderA2

- 
  - 
    - runatend.sql

I could then do:  
\<includeAll path="…/FolderA/FolderA1/"/\>  
… run whatever else here  
\<includeAll path="…/FolderA/FolderA2/"/\>

---

<div class="post-metadata">

**Author:** ![praneethvarmab](https://avatars.discourse-cdn.com/v4/letter/p/d2c977/32.png) [@praneethvarmab](https://forum.liquibase.org/u/praneethvarmab)\
**Post date:** [January 25, 2021, 3:05am UTC](https://forum.liquibase.org/t/sequentially-uploading-scripts-in-two-different-schemas/4960/5 "2021-01-25T03:05:10Z")

</div>

Thank you very much, this should work for the current sequence we have right now.

---

<div class="post-metadata">

**Author:** ![ronak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/ronak/32/221_2.png) [@ronak](https://forum.liquibase.org/u/ronak)\
**Post date:** [January 25, 2021, 1:15pm UTC](https://forum.liquibase.org/t/sequentially-uploading-scripts-in-two-different-schemas/4960/6 "2021-01-25T13:15:40Z")

</div>

@praneethvarmab ,

That’s great that it worked! Check out more examples in the Fundementals and Troubleshooting courses available on the [Liquibase University](https://learn.liquibase.com/).

-Ronak