I’m starting to use Team Coding in Toad 12.10 with an Oracle 12.1 database and TFS 2012. I’ve got it working for tables, indexes, constraints, etc. What I would like is to include the Database Links, Materialized Views, Jobs, and other things, but they don’t seem available when I select what objects to put under control. Why is that? Am I missing something in my configuration?
I’d also like to put a set of objects from a different database under control because they are all related to the same software application, but I manage one database and don’t have management access to the other (it’s a 3rd party database that allowed us to create a handful of triggers) I was hoping I could add a “folder” and just dump the trigger scripts there, but I may have to go old school and simply use Visual Studio to manage it. Any ideas?
No, you’re not missing anything in your configuration. Team Coding doesn’t currently support Database Links, Materialized Views, and Jobs. It only supports the object types displayed in the Team Project settings of the configuration window. If you would like, feel free to add an entry to the Idea Pond with the features you’d like, and we can take a look at what might be involved in implementing them.
For your second issue, I would probably recommend looking into Toad Intelligence Central (TIC) Community Edition. If the 3rd party database is Oracle, but doesn’t allow you to create custom schemas or objects other than triggers, you can store the Team Coding configuration within Toad Intelligence Central. Then, any time you connect to that 3rd party database (and you have a connection to the TIC configured), you can still do change control on the database since all the history is stored on the TIC server.
Let me know if that helps to solve what you need. If you have any questions, feel free to shoot me an e-mail offline and I’ll see what I can do to help.