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.

These fields display in the typical view.

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