Hi John,

>1. One project contains 10 files, 5 of them are in VSS database A and the rest stored in VSS database B.

Does this work in your project?

Based on everything I know this shouldn't work in VFP. VFP stores the name of the database in the project header, not on a file by file basis. Additionally, VFP logs onto the VSS database once for each project, not once for each file. There's only one handle to the VSS database. Before version 8, VFP even could only connect to the current database. If it found a project with the same name, VFP used that one, even if the project was originally checked into a different database.

Hence, what would happen in VFP 7 is every time you operate on a file in the non-current database, you get a login dialog and have to pick the database. In VFP 8, you probably get an error, because VFP cannot find the files in the current database. This behavior is by design, VFP isn't designed to work on more than one database at a time.

>May be it is a bit weird on the "design", but I just wan to "resolve" it because I can't find any tool to merge them into one database.

There are SSARC and SSRESTOR, two tools that come with Visual SourceSafe to move files and projects from one database to another, or save only certain parts of a project. See:

http://jeays.net/files/vss-ssarc-ssrestor.htm
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/guides/html/vsgrfss_arc.asp