How to: Set Up SQL Express for Migration

Article
11/27/2007

You must install SQL Express on the computer on which you are running converter for migration. The VSS Converter reads the history of individual files and folders in the Visual SourceSafe database and stores this history in SQL Express. The converter then sorts the history and does some additional processing. Finally, it reads the history from SQL Express and start the migration.

You must make sure that you have admin rights on SQL Express. If you install Visual Studio 2005, you automatically have admin rights.

Note

The converter may exit in the preparation phase of migration of a very large Visual SourceSafe database because of the 4GB limit of SQL Express. To continue, you must either set the converter to use SQL Server instead of SQL Express, or try migrating smaller folders or a partial history using the Visual SourceSafe Archive feature. You can set converter to use SQL server in settings file.

For running the source control migration analysis, you must be a system administrator for SQLExpress. By default, if you have installed Visual Studio, you will already have the required privileges for SQLExpress. If you are not a system administrator for the installed SQLExpress, a system administrator must add you as a system administrator.

Required Permissions

To perform this procedure, you must be a member of the Administrators security group on the computer. You must also be a member of the sysadmin server role for SQL Express. By default, you are a member of the sysadmin server role if you are a member of the Administrators security group on the computer where SQL Express is installed. For more information, see "sysadmin" (https://go.microsoft.com/fwlink/?LinkId=60405) in the SQL Server 2005 documentation.

To add a system administrator for SQLExpress

Install SQL Express on the computer on which you will run the Visual SourceSafe Converter. When you install Visual Studio 2005, SQL Express is installed by default.
Navigate to the folder where SQLCMD.exe is located (by default SQLCMD.exe is installed in <root>:\Program Files\Microsoft SQL Server\90\Tools\Binn) and at the command prompt, type the following commands:
```
            SQLCMD.exe -S localhost\SQLExpress -E
EXEC sp_grantlogin <username> -- add as user
GO
EXEC sp_addsrvrolemember <username>, 'sysadmin' 
GO
```

How to: Set Up SQL Express for Migration

To add a system administrator for SQLExpress

See Also

Tasks

Additional resources