I have an Oracle database that I connect to from Visual Studio 2010 (Oracle Developer Tools). Now I have a database in the Server Explorer window and you can see all the tables, views, functions, etc.
Now I want to have all of these objects in my database solution (I want to use the TFS version control, so I want all the objects in my solution). I can right-click on the single function and select "Generate Create Script to Project", then it will do exactly what I want, it creates a new Script in the folder "Functions" of the database project with the same name as the function .
Problem:
If I select two or more functions and use the "Create Script to Project Function" function, then I need to select a name for the Script and write all the functions in one script. But I want one file per script.
Question:
Is it possible to somehow export all objects from the oracle database and import them as Script into a Visual Studio database project?
If I use a different driver (devart), then I can do it, but we want to use ODT, and I could not find an easy way to complete this task. Edit: Just noticed that the devart project is incompatible with source control, so we absolutely need to go with ODT.
Feroc source share