Retrieve a Database Item of Specified Version
To ensure that each version of a database item is recoverable, SQLSourceSafe provides
version control and history functions utilizing Visual SourceSafe's capability.
The date/time stamp is used to record when a file is created or checked in.
To access to database item history, choose SourceSafe\History from main
menu or right click the item on the SourceSafe pane and then select History
from the context menu. The system will open the History Option Dialog box
prompting user to specify search criteria to filter the item history. The
search/filter options are: starting time (From), end time (To),
and the user account in Visual SourceSafe (User). If all fields are
specified, only the changes made by the specified user during the specified
time period will be displayed.
Figure 1 SQLSourceSafe Item History Option Dialog
The next screen shows the history result based on the search
option.
Figure 2 SQLSourceSafe Item History
To retrieve a database item of specified version. You can highlight the version you want to
retrieve in the Item History dialog.
Then click the Get button.
The script of database item of specified version in SourceSafe will
update the database item in SQL Server.
If the database item does not exist in the SQL Server, a new database
item will be created.