We are several developers working on a pretty big Oracle database and we need to be able to keep versionning of database modifications.
The best solution we found was to export schema objects to different files (so one file for each table, view, stored procedure, package, etc..) so we can use SVN (Subversion) to keep track of each developer modification.
This also allows us to use a common tool to version database files and .NET application files.
As a consequence we need to be able to export schema objects of an Oracle database to different files (so each one can select objects he modified to script them to file).
I didn't find this option in OraDeveloper Studio.
Is there a way to do this ?
If not, is it planned for a future release and when will it be avalaible ?
Regards,
Eric
Exporting to separate files
You can create a database project within OraDeveloper Studio to accomplish this task. New Project wizard allows you to import object from existing database to separate files. For more information please refer to the product documentation.As a consequence we need to be able to export schema objects of an Oracle database to different files (so each one can select objects he modified to script them to file).
correction
You're right I didn't find the option at first.
Is it possible, if someone modify the database outside of the projet, to resynchronize the file with the database (as it is done when first creating the project) ?
Regards,
Eric
Is it possible, if someone modify the database outside of the projet, to resynchronize the file with the database (as it is done when first creating the project) ?
Regards,
Eric