Importing into VCS?

[Stefan Sigurdsson]

Hi there,

I'm trying to import an existing, large database into a version control system. Using PL/SQL Developer to do a file-per-object export to the file system results in roughly 1000 files.

I'm having a hard time figuring out how to get all these user objects into the source control system.

I found an excellent post on integrating PL/SQL Developer with Subversion using the VCS plug-in on this forum:

http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=002444;p=1#000004

It mentions one way to import objects, e.g. to right-click the object and work through several dialogs. I have too many files for that.

I'd appreciate if somebody could point out a convenient way to export the user objects and import them into the source control system.

 

[Stefan Sigurdsson]

Ping... there has to be somebody here that has imported a large existing database into version control and used with PL/SQL Developer?

 

[Aviga]

Hello,

It depends on your source control system. You should be able to export database objects to files using PL/SQL Developer (one file per object), rename the files or create some directories if you wish, and then use your source control system 'import' feature to add all the objects at once (including the directory structure you may have created). It would certainly work with CVS for example.

Cheers,