VCS & VSS Integration

[davidsette]

Hello,

I'm trying to integrate the VCS plug-in with Visual Source Safe.
I've managed to set it all up (seems to be correct) but I'm wondering what the best way to place the scripts for my database objects under source control.
I would like to know if there's a way to generate the scripts for both the objects and the data, and place those into VSS, all using the PLSQL Developer GUI.
Any suggestions would be greatly appreciated.

Best Regards,
David

 

[Marco Kalter]

The VCS Plug-In allows you to place any source file under source control. For PL/SQL sources you can simply place the "create or replace" files under source control. For team development, it is preferred to use one file per object, and also separate the package (or type) body and specification in a separate file.

Source control for table objects is not quite as trivial. It is easy to extract the creation DDL for an object and place it under source control, but subsequent modifications should probably be added as separate files. This way you get (for example) a creation file for the base table, and a file for subsequent "alter table" statements.

The data is typically not part of "the source files", though for specific reference tables you may want to provide a standard set of records. If you create a command file for this n the Command Window, you can place this under source control as well.