Share via


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 Parent

Cardinality

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).

See Also

Reference

Restore Element (XMLA)
Synchronize Element (XMLA)

Concepts

Properties (XMLA)

Help and Information

Getting SQL Server 2005 Assistance