Kevin.Gao.Blog()

Visual SourceSafe (VSS) users are based on VSS databases. When a VSS database is created, there will be two default users added to the database: Admin and Guest. As the database administrator, we need to add user accounts for all of the users who will work on the database.

To add a user in a VSS database, please follow steps below:

1. Log in Visual SourceSafe Administrator as Admin.

2. On the File menu, click Open SourceSafe Database to select a VSS database.

(Open SourceSafe Database)

3. On the Users menu, click Add User to bring up the Add User dialog box.

(Add User)

4. Input the user name and password. Check the Read only option to assign the new user read-only permissions for the current database, or leave it unchecked to assign the new user read-write permissions.

5. Click OK to finish adding a new user.

To edit a user in a VSS database, we can click Edit User on the Users menu in Visual SourceSafe Administrator, or we can just double-click the selected user, and the Edit User dialog box will prompt, as seen in the following screen shot:

(Edit User)

If other users forget their passwords, we as Admin can click Change Password on the Users menu in Visual SourceSafe Administrator to reset their passwords.

(Change Password)

The SQL Server-based Source Control Software Designed to be a SourceSafe Replacement

The Fastest SourceSafe Remote Access Tool Recommeded by Microsoft

Links:
Previous article <<<<: How to backup & restore SourceSafe / VSS database
Next article >>>>: How to Manage Security in SourceSafe / VSS
SourceSafe How To series home page: VSS / SourceSafe Tutorial

Visual SourceSafe can be integrated into Flash (Professional edition only) to source control projects. To use source control functions, we should define a site for the project.

1. Open Flash.

2. Click menu Site -> Edit Sites to New or Edit a site.

(New or Edit a site)

3. In the Site Definition dialog box, choose Microsoft® Visual SourceSafe® as the connection type.

(Site Definition)

4. Check Project under menu Window to display the dialog box of the Project panel. Also, the dialog box of the Project panel can be dragged to the right menu.

5. After creating a new project or opening an existing project, right click the project to show the Project Settings dialog box, and then select a site from the Site menu in the Version Control section and click OK.

(Connect to remote host)

Input the information of Database Path, Project, Username and Password in the Microsoft® Visual SourceSafe® Database dialog box to open SourceSafe database.

(Open SourceSafe database)

6. Now the project is in the source control of SourceSafe. You can find the SourceSafe functions by clicking the icon or right-clicking the project.

(Use SourceSafe in Flash)

7. When a project has version control applied, we can also open it by using Open from Site. Click menu File -> Open from Site. In the Open from Site dialog box, select the site from the Site menu and then select the file in the site.

The SQL Server-based Source Control Software Designed to be a SourceSafe Replacement

The Fastest SourceSafe Remote Access Tool Recommeded by Microsoft

Links:
Previous article <<<<: Integrating SourceSafe / VSS with Dreamweaver
Next article >>>>:
SourceSafe How To series home page: VSS / SourceSafe Tutorial

Visual SourceSafe can be integrated into Dreamweaver to source control projects and files.

1. Open Dreamweaver.

2. Click Site menu -> Manage Sites to create a New site or to Edit a site.

(New or Edit a site)

3. In the Site Definition dialog box, go to the Advanced tag, select the Remote Info Category and choose Microsoft® Visual SourceSafe® as the access type.

(Remote Info of site)

After doing this, the source control panel will be displayed.

(Source control panel in Dreamweaver)

4. Click the Connect button to connect to remote host.

(Connect to remote host)

Input the information of Database Path, Project, Username and Password in the Microsoft® Visual SourceSafe® Database dialog box to open SourceSafe database.

(Open SourceSafe database)

5. Now the objects are in the source control of SourceSafe. You can find the SourceSafe functions by clicking the icons or right-clicking the items.

(Use SourceSafe in Dreamweaver)

The SQL Server-based Source Control Software Designed to be a SourceSafe Replacement

The Fastest SourceSafe Remote Access Tool Recommeded by Microsoft

Links:
Previous article <<<<:
Next article >>>>: Integrating SourceSafe / VSS with Flash
SourceSafe How To series home page: VSS / SourceSafe Tutorial

The Visual SourceSafe integration with SQL Server Management Studio (SSMS) 2005 is virtually identical to SQL Server Management Studio (SSMS) 2008.

Similar to SSMS 2008, we cannot version control SQL objects directly in SSMS 2005. However, we can create scripts for the database and all its objects, save them to a solution and then add the solution to source control. For more details, please refer to another article: How to add SQL Server 2005/2008 Stored Procedures to VSS.

Here are the steps we can follow:
1. Install Visual SourceSafe on the machine hosting SQL Server 2005.

2. Open SQL Server Management Studio 2005, and click menu Tools -> Options -> Source Control. In the Source Control page, we can select Microsoft Visual SourceSafe as the current source control plug-in.

(SQL Server 2005 Options)

3. Open an existing project/solution or create a new one through the SQL Server Management Studio menu File. We can open the solution explorer by click menu View -> Solution Explorer.

4. Next, we need to add the solution/project into source control by right-click the solution/project file and clicking Add Solution to Source Control menu.

5. We can add existing item/ new connection/ new query by right-clicking the project file and click Add. These items will be in the Pending Checkins window. After checking in, the items will be under source control by VSS.

For the Visual SourceSafe integration with SQL Server Management Studio 2008, please refer to my other article: Integrating SourceSafe / VSS with SQL Server 2008.

The SQL Server-based Source Control Software Designed to be a SourceSafe Replacement

The Fastest SourceSafe Remote Access Tool Recommeded by Microsoft

Links:
Previous article <<<<: Integrating SourceSafe / VSS with SQL Server 2008
Next article >>>>:
SourceSafe How To series home page: VSS / SourceSafe Tutorial