Version Control on Script Files for Oracle - Work Around

Version Control on Script Files for Oracle - Work Around

Hi All
As dbForge for Oracle does not have Source Control added I wanted to share how I get around this issue with the Community.

dbForge allows us to create a new project from an existing schema.  File=> New Project.
This feature, extracts the schema into separate files



1. Point the project to a existing git repo
2. Select the Import schema objects
3. Select Include All Objects
4. Select Create a physical folder on the disk
5. Hit Create

This will then create a set of DDL SQL files in the folder.
Open your Git Repo Tools and commit this as a baseline.

Then when you run the same process again later after there are changes to your database, the SQL files will be updated, but only the changed ones will be candidates for commit to the repo.
Thus over time you have a repo that now reflects that changes in the database