Online Documentation for SQL Manager for SQL server

Store objects definitions in VCS


If you want your objects to be under version control system, perform the following steps.

  1. Proceed to the DDL to Files tab of the Database Registration Info dialog and enable the CheckBox Write object definition to a file after compilation option.
  2. Define the directory which will be used for storing object file names in the Root folder for storing object definitions field. In order to make files be under version control this directory must be a working copy.
  3. Choose object types and add files for storing objects definitions using the Options for storing object definitions and Object file names correspondingly. These files can be added to version control system.
  4. Use the following fields of the DDL to Files tab to define version control system commands on actions performed with objects files:
  • OS command after creating a file

Enter any command that will be executed after a file with object definition is created.

If you are using version control system then, for example, the following command can be entered: svn add {file_name} (for Subversion revision control system) where {file_name} stands for the respective newly created name of a file with object definition.

 

  • OS command before updating a file

Enter any command that will be executed before a file with object definition is updated.

If you are using version control system then, for example, the following command can be entered: ss checkout {file_name} -C- (for Visual Source Safe revision control system) where {file_name} stands for the respective name of a file with object definition being updated.

 

  • OS command after deleting a file

Enter any command that will be executed after a file with object definition is deleted.

If you are using version control system then, for example, the following command can be entered: svn del {file_name} (for Subversion revision control system) where {file_name} stands for the respective name of a file with object definition being deleted.