+

Search Tips   |   Advanced Search

SQL Server: SQL Server worksheet: Transfer to multiple databases

When use the database transfer option, we can use the condition to create multiple databases in the Configuration Wizard. This condition is selected by default. This worksheet highlights the fields and properties that we see in the Configuration Wizard when use the multiple databases condition.


Typical fields

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

The following table lists the typical fields that display when we select the condition to transfer the data to multiple databases. To see additional fields that apply to an advanced configuration, click Advanced.

Field Label Property Conditions Your Value
Release database name release.DbName
Release data source release.DataSourceName
Release database URL release.DbUrl
Release Admin URL release.AdminUrl
Release database home directory release.DbHome
Community database name community.DbName
Community data source community.DataSourceName
Community database URL community.DbUrl
Community Admin URL community.AdminDbUrl
Community database home directory community.DbHome
Customization database name customization.DbName
Customization data source customization.DataSourceName
Customization database URL customization.DbUrl
Customization Admin URL customization.AdminUrl
Customization database home directory customization.DbHome
JCR database name JCR.DbName
JCR data source JCR.DataSourceName
JCR database URL JCR.DbUrl
JCR Admin URL JCR.AdminUrl
JCR database home directory JCR.DbHome
Feedback database name feedback.DbName
Feedback data source feedback.DataSourceName
Feedback database URL feedback.DbUrl
Feedback Admin URL feedback.AdminUrl
Feedback database home directory feedback.DbHome
Likeminds database name likeminds.DbName
Likeminds data source likeminds.DataSourceName
Likeminds database URL likeminds.DbUrl
Likeminds Admin URL likeminds.AdminUrl
Likeminds database home directory likeminds.DbHome
Microsoft SQL Server library sqlserver2005.DbLibrary
Configuration user ID The value entered is copied to fields in the Advanced view for the dbdomain.DbUser properties. To see this field, continue to use the Yes selection for using the same user ID and passwords across portal database domains.
Configuration password The value entered is copied to fields in the Advanced view for the dbdomain.DbPassword properties.
Database administrator ID The value entered is copied to fields in the Advanced view for the dbdomain.DBA.DbUser properties.
Database administrator password The value entered is copied to fields in the Advanced view for the dbdomain.DBA.DbPassword properties.
Release configuration user release.DbUser To see this field, select No for using the same user ID and passwords across portal database domains.
Release configuration password release.DbPassword
Release database administrator release.DBA.DbUser
Release database administrator password release.DBA.DbPassword
Community configuration user community.DbUser
Community configuration password community.DbPassword
Community database administrator community.DBA.DbUser
Community database administrator password community.DBA.DbPassword
Customization configuration user customization.DbUser
Customization configuration password customization.DbPassword
Customization database administrator customization.DBA.DbUser
Customization database administrator password customization.DBA.DbPassword
JCR configuration user jcr.DbUser
JCR configuration password jcr.DbPassword
JCR database administrator jcr.DBA.DbUser
JCR database administrator password jcr.DBA.DbPassword
Feedback configuration user feedback.DbUser
Feedback configuration password feedback.DbPassword
Feedback database administrator feedback.DBA.DbUser
Feedback database administrator password feedback.DBA.DbPassword
Likeminds configuration user likeminds.DbUser
Likeminds configuration password likeminds.DbPassword
Likeminds database administrator likeminds.DBA.DbUser
Likeminds database administrator password likeminds.DBA.DbPassword
Runtime user The value entered is copied to fields in the Advanced view for the dbdomain.DbRuntimeUser properties. To see this field:

  • Continue to use the Yes selection for using the same user ID and passwords across portal database domains.

  • Continue to use the default selection of Yes for needing a runtime database user for day-to-day operations.

Runtime password The value entered is copied to fields in the Advanced view for the dbdomain.DbRuntimeDbRuntimePassword properties.
Release runtime user release.DbRuntimeUser To see this field:

  • Select No for using the same user ID and passwords across portal database domains.

  • Continue to use the default selection of Yes for needing a runtime database user for day-to-day operations

Release runtime password release.DbRuntimePassword
Community runtime user community.DbRuntimeUser
Community runtime password community.DbRuntimePassword
Customization runtime user customization.DbRuntimeUser
Customization runtime password customization.DbRuntimePassword
JCR runtime user jcr.DbRuntimeUser
JCR runtime password jcr.DbRuntimePassword
Feedback runtime user feedback.DbRuntimeUser
Feedback runtime password feedback.DbRuntimePassword
Likeminds runtime user likeminds.DbRuntimeUser
Likeminds runtime password likeminds.DbRuntimePassword


Parent topic: SQL Server: Database transfer