# Object palette and version control

**URL:** <https://forums.toadworld.com/t/object-palette-and-version-control/30229>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [June 20, 2014, 4:44am UTC](https://forums.toadworld.com/t/object-palette-and-version-control/30229 "2014-06-20T04:44:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![the\_new\_mr](https://avatars.discourse-cdn.com/v4/letter/t/e9bcb4/32.png) [@the\_new\_mr](https://forums.toadworld.com/u/the_new_mr)\
**Post date:** [June 20, 2014, 4:44am UTC](https://forums.toadworld.com/t/object-palette-and-version-control/30229/1 "2014-06-20T04:44:56Z")

</div>

Hello,

I’m using Toad version 12.1.0.22 I’m trying to use version control software with it. I have followed the steps to set up version control (using Git) and am able to open the version control software and see files checked in etc.

However, I am unable to check procedures or anything like that into version control.

According to this guide,

[http://dev.toadforsqlserver.com/webhelp/Content/Version\_Control/Manage\_Version\_Control\_for\_Scripts.htm](http://dev.toadforsqlserver.com/webhelp/Content/Version_Control/Manage_Version_Control_for_Scripts.htm)

I should be able to right click on an object in the “Object Explorer” and add it to version control. However, I don’t seem to have the same object explorer as mentioned in the knowledge article. I have something called an “Object Palette” where the only types of objects are Tables, Views and Synonyms and there is no option to add to version control when right clicking on any of the objects listed.

Am I missing something? Or has Toad recently removed the Object Explorer along with its functionality?

---

<div class="post-metadata">

**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\
**Post date:** [June 20, 2014, 5:07am UTC](https://forums.toadworld.com/t/object-palette-and-version-control/30229/2 "2014-06-20T05:07:32Z")

</div>

That document is for Toad for SQL Server, not Toad for Oracle.

---

<div class="post-metadata">

**Author:** ![Stephen.Beausang\_734](https://avatars.discourse-cdn.com/v4/letter/s/bc8723/32.png) [@Stephen.Beausang\_734](https://forums.toadworld.com/u/Stephen.Beausang_734)\
**Post date:** [June 20, 2014, 5:27am UTC](https://forums.toadworld.com/t/object-palette-and-version-control/30229/3 "2014-06-20T05:27:03Z")

</div>

Hello,

In Toad for Oracle, I think you would do this in the Schema Browser. The blog you referenced is for Toad for SQL Server, which has a different feature set  
to Toad for Oracle. If you use Team Coding, you can checkin/checkout from the schema browser. The Team Coding menu will be enabled when the objects are controlled. There are a number of blogs and papers on ToadWorld about setting up and using Team Coding.

If you are using legacy file based version control, you can checkin/checkout the objects by opening the source files in the editor. The Team Coding toolbar  
will be enabled to allow you to checkout/checkin the files.

You can also check out and open the files from the VCS Browser. It you are already able to login to Git, then you are setup to do this.

Stephen

**From:** the\_new\_mr [[mailto:bounce-the\_new\_mr@toadworld.com](mailto:bounce-the_new_mr@toadworld.com)]

**Sent:** Friday, June 20, 2014 7:46 AM

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

**Subject:** [Toad for Oracle - Discussion Forum] Object palette and version control

**[Object palette and version control](http://www.toadworld.com/products/toad-for-oracle/f/10/t/22191.aspx)**

Thread created by the\_new\_mr

Hello,

I’m using Toad version 12.1.0.22 I’m trying to use version control software with it. I have followed the steps to set up version control (using Git) and am able to open the version control software and see files checked in etc.

However, I am unable to check procedures or anything like that into version control.

According to this guide,

[http://dev.toadforsqlserver.com/webhelp/Content/Version\_Control/Manage\_Version\_Control\_for\_Scripts.htm](http://dev.toadforsqlserver.com/webhelp/Content/Version_Control/Manage_Version_Control_for_Scripts.htm)

I should be able to right click on an object in the “Object Explorer” and add it to version control. However, I don’t seem to have the same object explorer as mentioned in the knowledge article.  
I have something called an “Object Palette” where the only types of objects are Tables, Views and Synonyms and there is no option to add to version control when right clicking on any of the objects listed.

Am I missing something? Or has Toad recently removed the Object Explorer along with its functionality?

To reply, please reply-all to this email.

[Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/22191.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/t/22191.aspx?AbuseContentId=cc83d869-3afe-4512-b89b-b0321fa2446b&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/o/04j0/fb2d1dfd/ov1n8yne.gif)

---

<div class="post-metadata">

**Author:** ![the\_new\_mr](https://avatars.discourse-cdn.com/v4/letter/t/e9bcb4/32.png) [@the\_new\_mr](https://forums.toadworld.com/u/the_new_mr)\
**Post date:** [June 20, 2014, 9:13am UTC](https://forums.toadworld.com/t/object-palette-and-version-control/30229/4 "2014-06-20T09:13:22Z")

</div>

Oh sorry. I didn’t realise it was for Toad for SQL server. My bad.

I guess that for now, the best way to handle it is to check out a file from Git or just open the file from the hard drive from within Toad and then Git will detect any changes made to the file from there.

I was kind of hoping to find a way to automatically export and track all changes in the DB in the version control but it seems that this can’t be done unfortunately.

I’ll look into Team Coding a little as it may help.

Thanks for your quick and helpful replies.

---

<div class="post-metadata">

**Author:** ![Stephen.Beausang\_734](https://avatars.discourse-cdn.com/v4/letter/s/bc8723/32.png) [@Stephen.Beausang\_734](https://forums.toadworld.com/u/Stephen.Beausang_734)\
**Post date:** [June 20, 2014, 10:39am UTC](https://forums.toadworld.com/t/object-palette-and-version-control/30229/5 "2014-06-20T10:39:06Z")

</div>

It sounds like Team Coding may be able to do what you need. I you set up a Code Collection to control your database objects, you can create a new revisions  
of your database objects in Git. Team Coding also automatically checks out/ in your objects from the local Git repository.

**From:** the\_new\_mr [[mailto:bounce-the\_new\_mr@toadworld.com](mailto:bounce-the_new_mr@toadworld.com)]

**Sent:** Friday, June 20, 2014 12:14 PM

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

**Subject:** RE: [Toad for Oracle - Discussion Forum] Object palette and version control

**[RE: Object palette and version control](http://www.toadworld.com/products/toad-for-oracle/f/10/p/22191/47318.aspx#47318)**

Reply by the\_new\_mr

Oh sorry. I didn’t realise it was for Toad for SQL server. My bad.

I guess that for now, the best way to handle it is to check out a file from Git or just open the file from the hard drive from within Toad and then Git will detect any changes made to the file  
from there.

I was kind of hoping to find a way to automatically export and track all changes in the DB in the version control but it seems that this can’t be done unfortunately.

Thanks for your quick and helpful replies.

To reply, please reply-all to this email.

[Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/22191.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/22191/47318.aspx?AbuseContentId=f8d60637-d5ee-42e2-a062-33674876d234&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/o/04j0/2914cbac/ov5usg1e.gif)
