Share via

  • Article

ConnectionString Element (XMLA)

Contains a connection string used by the parent Location or Source element.

Syntax

<Location> <!-- or Source -->
   ...
   <ConnectionString>...</ConnectionString>
   ...
</Location>

Element Characteristics

Characteristic

Description

Data type and length

String

Default value

None

Cardinality
Ancestor or ParentCardinality
Location1-1: Required element that occurs once and only once.
Source0-1: Optional element that can occur once and only once.

Element Relationships

Relationship

Element

Parent elements

Location, Source

Child elements

None

Remarks

For Location elements, the ConnectionString element contains the connection string used by the Restore or Synchronize command to either update a local data source or connect to a remote instance.

For Source elements, the ConnectionString element contains the connection string used by the Synchronize command to connect to the source instance.

For more information about backing up and restoring objects, see Backing Up, Restoring, and Synchronizing Databases (XMLA).