Kevin.Gao.Blog

SourceSafe provides an Archive utility, with which we can periodically backup our VSS Database or projects and transport files/projects between SourceSafe databases. SourceSafe also provides a Restore tool which allows us to restore the data from an archive.

• How to archive SourceSafe database
• How to restore SourceSafe database

To archive a SourceSafe database:

1. First, make sure no one is using the database we are going to archive or the Analyze utility will not run during the process of archive.

2. Open the database in SourceSafe Administrator and start the Archive Wizard through menu Archive -> Archive Projects.

3. Choose the project to archive from the project list.

(Choose project to archive)

4. Click Add to add more projects we would like to archive and then click Next.

(Add projects you would like to archive)

5. Specify a name for the archive file.

(Specify name for the archive file)

6. Specify the version range of the project to archive. We may choose to archive all of the data or archive the data older than a specific version.

(Specify the version range to archive)

7. Click Finish and SourceSafe will archive the projects to an .ssa file.

To restore the projects from an archive file:

1. Start the Restore Wizard through SourceSafe Administrator menu Archive -> Restore Projects.

2. Select the archive file that contains the projects we would like to restore.

(Select archive file)

3. Select the projects we want to restore to the database. We can check the Display subproject option to see all the subprojects.

(Select projects to restore)

4. Specify the destination to restore the project. We may restore the project to where it was archived from or to a different location.

(Select restore destination)

5. After the restore operation is finish, we may log in SourceSafe to check if the projects we want have been properly restored.

Note: If we want to restore a complete backup of a VSS DB, it is recommended that we restore the backup to a new VSS database rather than an existing database.

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 >>>>: How to manage users in SourceSafe / VSS
SourceSafe How To series home page: VSS / SourceSafe Tutorial

PowerBuilder was a popular tool for database front end development. I used PowerBuilder 6 about 10 years ago to develop a MIS (Management Information System) application. The tool was powerful but in the past 5 years, PowerBuilder lost its ground to Java, .NET and other web development languages (like PHP). Recent market surveys show that PowerBuilder is not in the top 5 anymore.

The source code control interface of PowerBuilder is compatible with Microsoft’s MSSCCI, so we can use Microsoft Visual SourceSafe (VSS) or other compatible software as the version control tool.

To integrate Visual SourceSafe (VSS) with PowerBuilder, we can follow the steps below:

1. Right-click the selected workspace, and select Properties, as seen in the following screen shot:

(Properties of Workspace)

2. In Source Control tab, configure source control settings.

• In the Source Control System dropdown list, select Microsoft Visual SourceSafe.
• In User ID edit box, input the name of our VSS account.
• In Project edit box, input the VSS project in which we want put the selected local project. We can click the browse button next to choose the VSS project. When we click the browse button, the Log On to Visual SourceSafe Database window will prompt, as seen in the following screen shot:

(Log on to Visual SourceSafe Database)

• Log into the VSS database, and select a project to store the selected local project in the following screen shot.

(Add to SourceSafe)

• Click OK to finish the workspace binding.

3. In PowerBuilder System Tree, right-click the selected workspace, and select Add to Source Control to bring up the Add to Source Control window.

(Add to Source Control)

4. Click OK to add the selected items to the VSS database.

5. Now the target project is source controlled by VSS. We can perform the basic source control operations, such as Get Latest Version, Check Out, Check In, Undo Check Out, Add to Source Control, Show Differences, Show History and so on.

(Basic Source Control Operations)

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 >>>>:
SourceSafe How To series home page: VSS / SourceSafe Tutorial

SourceSafe can be integrated into Visual Basic 6.0 to source control the VB forms, modules, class modules, etc.

To integrate SourceSafe with VB 6.0, we can do as follows:

1. Choose SourceSafe as the current source control provider.
For information on how to do it, refer to: http://www.kevingao.net/sourcesafe/microsoft-source-code-control-interface-msscci-registry-entries.html

2. Open VB 6.0 and check if the Source Code Control add-in is loaded through menu Add-Ins -> Add-In Manager.

If yes, we should be able to find the SourceSafe command under Tools menu.
If no, please edit the vbaddin.ini file by going to Start -> Run: vbaddin.ini and adding the line “vbscc=3 ” in the file.

3. Add the VB project into source control of SourceSafe by clicking menu Tools -> SourceSafe -> Add Project to SourceSafe.

(Add VB Project to SourceSafe)

4. In the following Log On to SourceSafe Database dialog box, enter the credentials to log on a VSS DB.

(Log on to VSS Database)

5. Choose a location in the VSS project tree to store the VB project.

(Choose location to place the VB project)

6. Select the files we want to add into SourceSafe for source control and click OK.

(Add VB files to SourceSafe)

7. Now, all of the files are under source control of SourceSafe. We can find the SourceSafe functions through menu Tools -> SourceSafe. We can also access some of the functions by right-clicking the file in the Project Explorer.

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 Visual C++ 6.0
Next article >>>>: Integrating SourceSafe / VSS with Access 2007
SourceSafe How To series home page: VSS / SourceSafe Tutorial

SourceSafe can be integrated into Visual C++ 6.0 to source control VC projects and files.

To integrate SourceSafe with VC 6.0, we can do as follows:

1. Choose SourceSafe as the current source control provider.
For information on how to do it, refer to: http://www.kevingao.net/sourcesafe/microsoft-source-code-control-interface-msscci-registry-entries.html

2. Add the VC project into source control of SourceSafe by clicking menu Project -> Source Control -> Add to Source Control. We can also add the project by right-clicking the file in the Project Explorer.

(Add VC project to SourceSafe from menu)

(Add VC project to SourceSafe)

3. In the following Log On to SourceSafe Database dialog box, enter the credentials to log on a VSS DB.

(Log on to VSS Database)

4. Choose a location in the VSS project tree to store the VC project.

(Choose location to place the VC project)

5. Select the files we want to add into SourceSafe for source control and click OK.

(Add VC files to SourceSafe)

6. Now, all of the files are under source control of SourceSafe. We can find the SourceSafe functions through menu Project -> Source Control. We can also access some of the functions by right-clicking the file in the Project Explorer.

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 <<<<: Switching Visual Studio projects from SourceSafe to other SCC providers
Next article >>>>: Integrating SourceSafe / VSS with Visual Basic 6.0
SourceSafe How To series home page: VSS / SourceSafe Tutorial

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