VCS and Views

[William Campbell]

I am using Pl/SQL Developer 5.1.6 with the Version Control Interface 1.2 plugin.

I have 'Allow version control over DB objects' enabled in the VCS plugin.

A Visual Source Safe project has been set up which uses the file extension of '.vw' for views.

In tools/preferences/File extensions I can't see anywhere to set the file type for views. This means (I think) that PL/SQL developer doesn't recognise views that are in the VSS database with a .vw extension and I don't get a 'Check Out' option in the object browser popup menu.

I do however get the 'Check Out' option for other types of objects that are in the VSS database (for example package bodies and headers).

I have tried setting the file type for 'SQL Scripts' to vw but that doesn't help.

Does anyone have any ideas as to how I can get this to work?

Thanks,

William

 

[Marco Kalter]

This does indeed only work for PL/SQL object types. It does not work for views, tables, and so on. You will have to explictly check-out and check-in these .vw files.