Proveedor de detección de dirección de creación de reflejo de SQL 2014

Microsoft.SQLServer.2014.Mirroring.PrincipalToMirrorReferenceDiscoveryProvider (DataSourceModuleType)

Este tipo de módulo se usa para detectar la dirección de la creación de reflejo de la sesión de creación de reflejo de la base de datos de Microsoft SQL Server 2014.

Element properties:

Member Modules:

Overrideable Parameters:

Source Code:

<DataSourceModuleType ID="Microsoft.SQLServer.2014.Mirroring.PrincipalToMirrorReferenceDiscoveryProvider" Accessibility="Public">

  <Configuration>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="IntervalSeconds" type="xsd:integer"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SyncTime" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="PrincipalComputerName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="PrincipalInstanceName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="MirrorComputerName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="MirrorInstanceName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="DatabaseName" type="xsd:string"/>

  </Configuration>

  <OverrideableParameters>

    <OverrideableParameter ID="IntervalSeconds" ParameterType="int" Selector="$Config/IntervalSeconds$"/>

    <OverrideableParameter ID="SyncTime" ParameterType="string" Selector="$Config/SyncTime$"/>

  </OverrideableParameters>

  <ModuleImplementation>

    <Composite>

      <MemberModules>

        <DataSource TypeID="System!System.Discovery.Scheduler" ID="Scheduler">

          <Scheduler>

            <SimpleReccuringSchedule>

              <Interval Unit="Seconds">$Config/IntervalSeconds$</Interval>

              <SyncTime>$Config/SyncTime$</SyncTime>

            </SimpleReccuringSchedule>

            <ExcludeDates/>

          </Scheduler>

        </DataSource>

        <ConditionDetection ID="Filter" TypeID="System!System.ExpressionFilter">

          <Expression>

            <And>

              <Expression>

                <Or>

                  <Expression>

                    <SimpleExpression>

                      <ValueExpression>

                        <Value Type="String">$Config/PrincipalComputerName$</Value>

                      </ValueExpression>

                      <Operator>NotEqual</Operator>

                      <ValueExpression>

                        <Value Type="String">$Config/MirrorComputerName$</Value>

                      </ValueExpression>

                    </SimpleExpression>

                  </Expression>

                  <Expression>

                    <SimpleExpression>

                      <ValueExpression>

                        <Value Type="String">$Config/PrincipalInstanceName$</Value>

                      </ValueExpression>

                      <Operator>NotEqual</Operator>

                      <ValueExpression>

                        <Value Type="String">$Config/MirrorInstanceName$</Value>

                      </ValueExpression>

                    </SimpleExpression>

                  </Expression>

                </Or>

              </Expression>

              <Expression>

                <SimpleExpression>

                  <ValueExpression>

                    <Value Type="String">$Config/PrincipalInstanceName$</Value>

                  </ValueExpression>

                  <Operator>NotEqual</Operator>

                  <ValueExpression>

                    <Value Type="String"/>

                  </ValueExpression>

                </SimpleExpression>

              </Expression>

              <Expression>

                <SimpleExpression>

                  <ValueExpression>

                    <Value Type="String">$Config/MirrorInstanceName$</Value>

                  </ValueExpression>

                  <Operator>NotEqual</Operator>

                  <ValueExpression>

                    <Value Type="String"/>

                  </ValueExpression>

                </SimpleExpression>

              </Expression>

            </And>

          </Expression>

        </ConditionDetection>

        <ConditionDetection ID="Mapper" TypeID="System!System.Discovery.RelationshipSnapshotDataMapper">

          <RelationshipId>$MPElement[Name='Microsoft.SQLServer.2014.Mirroring.PrincipalReferencesMirror']$</RelationshipId>

          <SourceRoleSettings>

            <Settings>

              <Setting>

                <Name>$MPElement[Name="Windows!Microsoft.Windows.Computer"]/PrincipalName$</Name>

                <Value>$Config/PrincipalComputerName$</Value>

              </Setting>

              <Setting>

                <Name>$MPElement[Name='SQL2014Core!Microsoft.SQLServer.2014.ServerRole']/InstanceName$</Name>

                <Value>$Config/PrincipalInstanceName$</Value>

              </Setting>

              <Setting>

                <Name>$MPElement[Name='SQL2014Core!Microsoft.SQLServer.2014.Database']/DatabaseName$</Name>

                <Value>$Config/DatabaseName$</Value>

              </Setting>

            </Settings>

          </SourceRoleSettings>

          <TargetRoleSettings>

            <Settings>

              <Setting>

                <Name>$MPElement[Name="Windows!Microsoft.Windows.Computer"]/PrincipalName$</Name>

                <Value>$Config/MirrorComputerName$</Value>

              </Setting>

              <Setting>

                <Name>$MPElement[Name='SQL2014Core!Microsoft.SQLServer.2014.ServerRole']/InstanceName$</Name>

                <Value>$Config/MirrorInstanceName$</Value>

              </Setting>

              <Setting>

                <Name>$MPElement[Name='SQL2014Core!Microsoft.SQLServer.2014.Database']/DatabaseName$</Name>

                <Value>$Config/DatabaseName$</Value>

              </Setting>

            </Settings>

          </TargetRoleSettings>

        </ConditionDetection>

      </MemberModules>

      <Composition>

        <Node ID="Mapper">

          <Node ID="Filter">

            <Node ID="Scheduler"/>

          </Node>

        </Node>

      </Composition>

    </Composite>

  </ModuleImplementation>

  <OutputType>System!System.Discovery.Data</OutputType>

</DataSourceModuleType>