SQL Server: SQL Server worksheet: Transfer to a single database

When you use the database transfer option, you can select the condition to create a single database in the Configuration Wizard. This worksheet highlights the fields and properties that you see in the Configuration Wizard when you select the single database condition.

Typical fields

When you use the database transfer option, you answer questions about your environment. Some fields are required. Other fields are required or removed based on your selections for environment conditions.

The following table lists the typical fields that display when you select the option to transfer your data to a single database. To see additional fields that apply to an advanced configuration, click Advanced.

Table 1. Transfer to a single database..

You might not see all of the fields listed in this table. Use the Conditions column in this table to find out what selections are required to see the fields. If you do not see conditions listed for a field, the field always appears. A selection might result in multiple fields displaying in the wizard. For this type of selection, a selection listed in the Conditions column spans multiple field label rows.

Field Label Property Condition Your Value
Database name The value that you enter is copied to fields in the Advanced view for the dbdomain.DbName properties.    
Data source The value that you enter is copied to fields in the Advanced view for the dbdomain.DataSourceName properties.    
Database URL The value that you enter is copied to fields in the Advanced view for the dbdomain.DbUrl properties.    
Database home directory      
Configuration user ID The value that you enter is copied to fields in the Advanced view for the dbdomain.DbUser properties.    
Configuration password The value that you enter is copied to fields in the Advanced view for the dbdomain.DbPassword properties.    
Database administrator ID The value that you enter is copied to fields in the Advanced view for the dbdomain.DBA.DbUser properties.    
Database administrator password The value that you enter is copied to fields in the Advanced view for the dbdomain.DBA.DbPassword properties.    
Runtime user The value that you enter is copied to fields in the Advanced view for the dbdomain.DbRuntimeUser properties. To see this field, continue to use the default selection of Yes for needing a runtime database user for day-to-day operations.  
Runtime password The value that you enter is copied to fields in the Advanced view for the dbdomain.DbRuntimeDbRuntimePassword properties. To see this field, continue to use the default selection of Yes for needing a runtime database user for day-to-day operations.  
Release Admin URL      
Community Admin URL      
Customization Admin URL      
JCR Admin URL      
Feedback Admin URL      
Likeminds Admin URL      
Microsoft SQL Server library sqlserver2005.DbLibrary