Home > Teratrax Source Guard > Help > User Interface

User Interface

The main window of Teratrax Source Guard is composed of multiple panes. The Server Explorer pane on the left side of the screen lets you navigate all of your database objects in a tree structure composed of multiple nodes. Each node represents a different type of database objects. You can add your enterprise servers to the Server Explorer with a single right-click. By default, you have the "(local)" server added so you can start working with databases on the local computer right away. The Items pane displays a list of all items contained in the selected node of the Server Explorer. The moving Splitter separates the Server Explorer pane from the Items pane allowing you to change the size of both panes as required.

Navigating database objects with Server Explorer is very simple. After you connect, you can click on the + sign to expand each node. The Items pane on the right side lists all objects of the type you have selected in Server Explorer. Right-click items in the Items pane to get a list of all possible actions you can perform on the item (for example, Check In for a stored procedure that has been added to Visual SourceSafe). All the options you get by right-clicking on the list view or tree view are available from the main menu too. Depending on the node that is currently selected in Server Explorer, some of the main menu options will be enabled and some will be disabled. Unlike the popup menu that you get when you right-click on a node or item, the main menu always lists all available functions, however, only the ones that apply to the current node or item are enabled.

The File Menu

• Connect: Opens the Connect dialog box to connect to a SQL Server instance
  • Windows Authentication: Use a Windows security account for authentication. The client needs to be part of a Windows domain or workgroup
  • SQL Server Authentication: Use a SQL Server security account for authentication
  • Login Name: The username for SQL Server authentication
  • Password: The password for SQL Server authentication
  • Remember connection parameters to this server: If this box is checked, Teratrax Source Guard will remember the information entered in this window so next time it will connect automatically. Information will be saved in an encrypted format
• Disconnect: Disconnects from a SQL Server instance.  Teratrax Source Guard uses connection pooling to allow for faster connections to SQL Server. If you need to completely remove the connections, simply close Teratrax Source Guard
• New SQL Window: Opens a new blank query window for you to write SQL commands
• Add Server: Registers a SQL Server in the Server Explorer. Edit the item name to reflect the server name or IP address you want to connect to. If you use an IP address, make sure the server can listen to IP connections and that the firewall allows for such a connection if the server has a firewall. For named instances of SQL Server 2000, use "Server Name"\"Instance Name" (for example, MyServer\Inst1)
• Remove Server: Removes a server from Server Explorer.
• Refresh: Update the Items pane

The Action Menu

• Stored Procedures
  • New: Creates a new stored procedure
  • Edit: Alters the selected stored procedure
  • Drop: Removes the selected stored procedure from SQL Server permanently
• Views
  • New: Creates a new view
  • Edit: Alters the selected view in the SQL window
  • Drop: Removes the selected view from SQL Server permanently
• Triggers
  • New: Creates a new trigger
  • Edit: Alters the selected trigger in the SQL window
  • Drop: Removes the selected trigger from SQL Server permanently
• Add to SourceSafe: Adds the selected object to Visual SourceSafe. Once the object is added to Visual SourceSafe, you should check it out before you can edit it. Dropping object that have been added to Visual SourceSafe is allowed since they can be recreated with the Get Latest option
• Check Out: Checks out the selected object from Visual SourceSafe. You can edit and drop the object after it has been checked out. Other users cannot edit or drop the object
• Check In: Checks in the selected object to Visual SourceSafe. You cannot edit the object after it has been checked in. To edit the object, you should check it out first. Dropping objects is allowed since they can be recreated from Visual SourceSafe with the Get Latest option
• Undo Check Out: Undoes Check Out and releases the lock on the object

The Tools Menu

• Visual SourceSafe Client: Opens the standard Microsoft Visual SourceSafe client. It will log you in automatically if your current windows user has the same login name and password as the one in your Visual SourceSafe database.
• Set SourceSafe Folder: Each database must have a Visual SourceSafe project folder defined before Teratrax Source Guard can check in/out/add to your Visual SourceSafe database. All Visual SourceSafe paths should be based on the following: $/<your project path>
• Options: The Options window allows you to configure Teratrax Source Guard
  • Path: the path where your Visual SourceSafe database is located. Path can be on your local hard disk or on your network folder
  • Username: Your user name in your Visual SourceSafe database (see your administrator for details if a username has not been assigned yet)
  • Password: Visual SourceSafe password
  • Use Windows username and password: Check this option if your Visual SourceSafe username and password are the same as your windows username and password
  • Working Folder: This folder is required in Teratrax Source Guard. It is defaulted to the installation folder when the product is initially installed

The Help Menu

• Help: Opens help
• About: Displays information about Teratrax Source Guard

Status Bar Information

The status bar is composed of the following boxes (from left to right):

• Number of items in the Items pane
• Last activity performed against the database

Keyboard Shortcuts

You can select any menu option in Teratrax Source Guard by simply holding the Alt key and pressing the appropriate menu shortcut (for example, Alt+F for the File menu). Additionally, you can access some of the most common features directly through keyboard shortcuts. This table displays all the keyboard shortcuts available in Teratrax Source Guard: