Hi girishere143,
Toad for Oracle 12.8 is an older version of Toad and was the last version to operate on the older Team Coding architecture. If possible, I would recommend upgrading to the current version of Toad for Oracle (or at least version 12.9 or higher) as that version of Team Coding was rewritten to be a whole lot easier and more stable to work with.
That being said, using Git in a Team Coding environment is not a simple task since distributed version control systems work very differently than what databases are used to. Databases operate more in a centralized (client/server) environment by nature. As such, many of the distributed commands needed (cloning, branching, pushing, pulling, and merging) need to be done manually as databases can't easily or safely restore code when switching between branches without running the risk of breaking other people's code.
Also, there's a distinction to be made about using Team Coding vs using File-based Source Control. Team Coding is primarily to be used in a team environment where multiple people are making updates to a database and you want to make sure people are working together, without stepping on each other's toes, while also handling change management and optionally version control management in an external version control provider. For change management, Team Coding will allow you to check out objects and lock them from modifications by others while you're working with them. If you tie it to a back-end version control system, it will also work with the VCS to provide version management for the DDL of those objects. Since it operates in a team environment, you'd need to have access to install the Team Coding objects to a centralized schema. As such, you'd probably need some level of access in order to have it used in your environment. To that end, I would probably ask your DBA to install the feature, or grant you permissions to install it, if you want to use it.
File-based source control allows you to simply integrate with a version control provider, but does not provide change control management in your database. As such, it doesn't require installing anything special on the server. Since it only works with files, you'd need to manually save the DDL for any objects you want to version to a folder on your local drive, then check out that file, make changes, compile it into the database, and then check it back in. However, other developers could also be changing the DDL of those objects at the same time you are. As a result, you may overwrite their changes if you don't know about them ahead of time. File-based Source Control doesn't provide change control management within the database itself to prevent unexpected alterations to objects by multiple different people at the same time.
For information about using Toad for Oracle 12.8 for file-based source control, you can look here:
For information about using Team Coding in Toad for Oracle 12.8, I would look at Anju's video from Dell's YouTube site here:
For information about setting up and using Team Coding in Toad 12.9 and higher, you can reference these pages:
- toad team coding integration with git (There's a PDF setup guide in the bottom comment)
- https://www.quest.com/video/setting-up-team-coding-with-vcs-integration8121746/
- https://blog.toadworld.com/2016/06/08/sql-navigator-team-coding-with-git (SQL Navigator uses Toad's Team Coding interface so the setup is similar)
For Toad 12.12 and earlier, there's also ways to set up external tools in Toad to perform clone, push, and pull operations. You can find out more about how to do that here:
Since you don't have administrative access in your environment, and unless other developers in your environment are also using Toad to make changes to your database, using file-based source control may be your best bet. If you are operating as a team in making database changes for various projects, it may be worthwhile to upgrade your version of Toad to a later version of Toad that supports a much easier Team Coding setup and integration.
I hope this information helps in providing some input to using Git in Toad for your environment. If you have any other questions, please feel free to let us know.
Thanks,
-John