VCS view extension

[NatalieH]

By default when I export user objects, the extension of the files including views is "vw". However when adding a view to source safe using the VCS plugin the extension of the file in source safe is "sql". Is there a way to check in a view with vw extension using version control over DB objects?

 

[Marco Kalter]

It will use the default extension for SQL scripts, which is .sql by default. You can change this, but you probably don't want all SQL scripts as .vw files.

A "View" file extension preference is on the list of enhancement requests.

 

[NatalieH]

I changed the default extension for sql scripts to VW just for this issue, and the VCS plug in still saves views with sql extension. It appears the VCS plugin doesn't look at preferences for this.

 

[Marco Kalter]

We'll check it out.