TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

ConnectionString Element (XMLA)

 

Applies To: SQL Server 2016 Preview

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

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

CharacteristicDescription
Data type and lengthString
Default valueNone
CardinalitySee the table below.
Ancestor or ParentCardinality
Location1-1: Required element that occurs once and only once.
Source0-1: Optional element that can occur once and only once.
RelationshipElement
Parent elementsLocation, Source
Child elementsNone

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

Restore Element (XMLA)
Synchronize Element (XMLA)
Properties (XMLA)

Community Additions

ADD
Show:
© 2016 Microsoft