Fournisseur de détection de la direction de la mise en miroir de SQL 2016

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

Ce type de module est utilisé pour déterminer la direction de mise en miroir de la session de mise en miroir de bases de données Microsoft SQL Server 2016.

Element properties:

Member Modules:

Overrideable Parameters:

Source Code:

<DataSourceModuleType ID="Microsoft.SQLServer.2016.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.2016.Mirroring.PrincipalReferencesMirror']$</RelationshipId>

          <SourceRoleSettings>

            <Settings>

              <Setting>

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

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

              </Setting>

              <Setting>

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

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

              </Setting>

              <Setting>

                <Name>$MPElement[Name='SQL2016Core!Microsoft.SQLServer.2016.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='SQL2016Core!Microsoft.SQLServer.2016.ServerRole']/InstanceName$</Name>

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

              </Setting>

              <Setting>

                <Name>$MPElement[Name='SQL2016Core!Microsoft.SQLServer.2016.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>