When you change which site database is active, you must identify either the server location for SQL Server databases or the Oracle net service for Oracle databases and name of the site database you want to activate. You must also specify the name and server location of its associative schema.
This page of the Database Wizard is only available as part of the Select an existing site database workflow.
Database type
Specifies the type of database.
Site database server
Sets the server on which the site database you want to activate currently resides. Only registered SQL Servers appear in the drop-down list. After you select a server for the site database, the Site schema server box defaults to match that of the site database server. This option appears only if you select SQL Server in the Database type list.
Oracle service (1)
Specifies the name of the Oracle net service for the site database connection. After you select the Oracle service, the Oracle service box for the site schema defaults to match that of the site database. This option appears only if you select Oracle in the Database type list.
Site database name
Sets the site database you want to activate. When you select the database, the software automatically populates the Site database workshare location and Name rule ID fields with the information that was defined for the specified database during its initial creation.
Site database workshare location
Displays the workshare location defined for the selected site database during its initial creation. This information is read-only.
Name rule ID
Displays the name rule ID of the selected site database as defined during its initial creation. This information is read-only.
Site schema server
Identifies the server on which the site schema database to activate resides. By default, the software displays the server location that you specified in the Site database server box. This option appears only if you select SQL Server in the Database type list.
Oracle service (2)
Specifies the name of the Oracle net service for the site schema database connection. By default, the software displays the service that you specified in the Oracle service box for the site database. This option appears only if you select Oracle in the Database type list.
Site schema name
Sets the site schema database you want to activate.
Name generator server for site
Displays the name of the server computer (as defined during the initial creation of the site database) on which the Name Generator Service is configured. You can specify an alternative server computer; however, it must be a valid computer running on the Windows domain and one that has been properly configured to run as a name server.