as a Dotnet and Oracle developer I happily stumbled across the ODT.
Unfortunately I have some problems in combination with the Team Foundation Server which hopefully someone of the experts here may solve.
So this is the environment...
Windows 7 Enterprise
Visual Studio 2010 prof.
ODT with ODAC 188.8.131.52.0
Team foundation Server 2012
Oracle Database 11g Release 184.108.40.206.0 - 64bit
Well, nearly everything seems to work.
I can connect to my Database Schema in the Server explorer, modify and save back views, functions, packages,... and save them back to the server.
I can create a new 'Oracle Database Project' in Visual Studio.
Now I right click and select 'Generate Create Script to Project'. This also works fine. The views or whatever I clicked are added to the Oracle Database Project.
Finally I select 'Add to Source Control' and the whole solution and all added scripts are checked in as desired.
I can now modify them, the're checked out automatically as used in th IDE of VS.
Works perfectly so far...
But now I have problems to add new scripts. This is turning me nuts.
I right click again on a new view, etc. and select 'Generate Create Script to Project'. The script is added to the Oracle Database Project like before.
The Project file also will be checked out as it now has a new file added. BUT the script file itselve won't be added to the source control.
And worse, I'm not easily able to add the file manually as in the context menu the command 'add to source control' or something similar is missing.
The only way is to open the windows explorer, move to the previously added script file and add it to the source control using the shell extensions of the power tools.
I cannot imagine that this is the designed way to add additional scripts to an ODP.
So is there anybody around who may tell me how to fix this ?
When you generate a script directly to an Oracle Database project, we add a timestamp to the file name. It won't match what is in source control. Have you tried right clicking on the file name and choosing Rename and renaming it to the name that your source control expects?
I guess I do not understand what you mean. I was talking about new Scripts. So your hint ' It won't match what is in source control' could not be the reason.
Creating a new Oracle Database Project, adding scripts to it and then adding this complete project in to the source control for the first time works fine.
Then later adding new scripts to this existing (already checked in) project which have not been in the TFS before fails. They wont automatically be marked as checked out (or newly added) as I know it from dotnet code when a new module or class is added to a existing solution/project which is already under TFS control.
Also there is no possibility to do this manually. E.g. Select 'Add to source control' in the context menu of the solution explorer won't be shown. The only way is the tricky workaround via the windows explorer extension. Not a professional alternative.
So this leaded us to the decission that this is not a way for us to deal with in our daily work. And so we took the less cheep way, bought the new SQL Navigator 7.0 which also could be fixed to the TFS2012.
Thanks anyway for your interest in my case. Will keep an eye on this board from time to time. If there is a solution, I will give it a try again.