Linking to a working folder
Published 26 July 2017
A working folder contains SQL script files that represent your database. The working folder can be source-controlled with your source control system in the same way you source-control other files.
When might I want to link to a working folder?
- If you want to do atomic commits of your database changes together with your application code, ensuring they are included in the same revision or changeset.
- If you are using a DVCS such as Git and you would prefer to commit and push as separate operations.
- If you prefer using your own preferred VCS client tool to manage your day-to-day version control changes.
When you link to a working folder, Source Control for Oracle doesn't automate any source control operations (eg add, push, edit etc). Instead:
- When you make changes to the database, the changes are listed in the Save changes tab. When you click Save changes, the changes are scripted as SQL files to the working folder. You can then commit the script files manually using your source control client.
- When the SQL files in the working folder are changed (eg by pulling with your source control system), the changes are listed in the Apply changes tab. When you click Apply changes, the changes are applied to your database.