Page 1 of 1

Exporting to separate files

Posted: Sat 25 Oct 2008 08:52
by emoreau
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

Posted: Mon 27 Oct 2008 07:40
by Duke
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).
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.

correction

Posted: Mon 27 Oct 2008 13:15
by emoreau
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

Posted: Mon 27 Oct 2008 13:29
by Duke
No it's not possible by now. At the current moment we have implemented schema synchronization tool in similar product for MySQL only.

Posted: Tue 28 Oct 2008 10:14
by emoreau
Do you plan to implement such a feature for OraDeveloper also ?
If yes, when do you plan to release this (even in Beta) ?

Posted: Tue 28 Oct 2008 12:20
by Duke
There are no near plans for this feature.