SqlChangeAutomation.Format.ps1xml
<?xml version="1.0" encoding="utf-8"?>
<Configuration> <ViewDefinitions> <View> <Name>Truncated Soc Release Artifact View</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.Domain.ReleaseArtifacts.SocReleaseArtifact</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <PropertyName>Target</PropertyName> </ListItem> <ListItem> <PropertyName>Source</PropertyName> </ListItem> <ListItem> <label>UpdateSql</label> <ScriptBlock> if ($_.UpdateSql.Length -gt 83) { $_.UpdateSql.Substring(0, 80) + "..." } else { $_.UpdateSql } </ScriptBlock> </ListItem> <ListItem> <label>ReportHtml</label> <ScriptBlock> if ($_.ReportHtml.Length -gt 83) { $_.ReportHtml.Substring(0, 80) + "..." } else { $_.ReportHtml } </ScriptBlock> </ListItem> <ListItem> <PropertyName>Warnings</PropertyName> </ListItem> <ListItem> <PropertyName>Filter</PropertyName> </ListItem> <ListItem> <PropertyName>Options</PropertyName> </ListItem> <ListItem> <PropertyName>IgnoreAdditional</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>ScriptsFolder View</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.Domain.Projects.ScriptsFolder</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <label>Scripts folder</label> <ScriptBlock> "'{0}'" -f $_.Description.Path </ScriptBlock> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>Truncated DatabaseSyncResult View</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.Domain.DatabaseSyncResult</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <label>UpdateSql</label> <ScriptBlock> if ($_.UpdateSql.Length -gt 83) { $_.UpdateSql.Substring(0, 80) + "..." } else { $_.UpdateSql } </ScriptBlock> </ListItem> <ListItem> <PropertyName>Warnings</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>SchemaDocumentation View</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.Documentation.SchemaDocumentation</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <label>Description</label> <ScriptBlock> "Schema documentation" </ScriptBlock> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>Soc Build Artifact View</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.Domain.BuildArtifacts.SocBuildArtifact</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <label>ScriptsFolder</label> <ScriptBlock> $_.ScriptsFolder.Description </ScriptBlock> </ListItem> <ListItem> <PropertyName>Id</PropertyName> </ListItem> <ListItem> <PropertyName>Version</PropertyName> </ListItem> <ListItem> <PropertyName>Description</PropertyName> </ListItem> <ListItem> <label>Documentation</label> <ScriptBlock> if ($_.SchemaDocumentation -ne $null) { "This package contains schema documentation" } else { "None" } </ScriptBlock> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>Formatted Test Results</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.SchemaTesting.TestResults</TypeName> </ViewSelectedBy> <TableControl> <TableHeaders> <TableColumnHeader> <Width>13</Width> </TableColumnHeader> <TableColumnHeader> <Width>13</Width> </TableColumnHeader> <TableColumnHeader> <Width>13</Width> </TableColumnHeader> <TableColumnHeader> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>TotalTestsRun</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>TotalErrors</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>TotalFailures</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>TestSuites</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>Formatted Test Case</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.SchemaTesting.TestCase</TypeName> </ViewSelectedBy> <TableControl> <TableHeaders> <TableColumnHeader> </TableColumnHeader> <TableColumnHeader> <Width>10</Width> </TableColumnHeader> <TableColumnHeader> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>Name</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Result</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Message</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>SQL Change Automation Project View</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.Domain.Projects.ScaProject</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <label>Project</label> <ScriptBlock> $_.SqlProjFileName </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.PackageScript -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Package Script</Label> <ScriptBlock> if ($_.PackageScript.Length -gt 100) { $lineSeparator = [System.Environment]::NewLine (($_.PackageScript -split '\r?\n' | Select-Object -First 5) -Join $lineSeparator) + "$lineSeparator..." } else { $_.PackageScript } </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.SnapshotPackageBytes -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Snapshot Package</Label> <ScriptBlock> "Snapshot" </ScriptBlock> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>SQL Change Automation Build Artifact View</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.Domain.BuildArtifacts.ScaBuildArtifact</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <label>Project</label> <ScriptBlock> $_.ScaProject.SqlProjFileName </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.PackageScript -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Package Script</Label> <ScriptBlock> if ($_.PackageScript.Length -gt 100) { $lineSeparator = [System.Environment]::NewLine (($_.PackageScript -split '\r?\n' | Select-Object -First 5) -Join $lineSeparator) + "$lineSeparator..." } else { $_.PackageScript } </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.SnapshotPackageBytes -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Snapshot Package</Label> <ScriptBlock> "Snapshot" </ScriptBlock> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>SQL Change Automation Release Artifact View</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.Domain.ReleaseArtifacts.ScaReleaseArtifact</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <label>Project</label> <ScriptBlock> $_.ScaProject.SqlProjFileName </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.PatchScript -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Patch Script</Label> <ScriptBlock> if ($_.PatchScript.Length -gt 100) { $lineSeparator = [System.Environment]::NewLine (($_.PatchScript -split '\r?\n' | Select-Object -First 5) -Join $lineSeparator) + "$lineSeparator..." } else { $_.PatchScript } </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.ProvisioningScript -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Provisioning Script</Label> <ScriptBlock> if ($_.ProvisioningScript.Length -gt 100) { $lineSeparator = [System.Environment]::NewLine (($_.ProvisioningScript -split '\r?\n' | Select-Object -First 5) -Join $lineSeparator) + "$lineSeparator..." } else { $_.ProvisioningScript } </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.DiffReport -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Diff Report</Label> <ScriptBlock> if ($_.DiffReport.Length -gt 83) { $_.DiffReport.Substring(0, 80) + "..." } else { $_.DiffReport } </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.DriftReport -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Drift Report</Label> <ScriptBlock> if ($_.DriftReport.Length -gt 83) { $_.DriftReport.Substring(0, 80) + "..." } else { $_.DriftReport } </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.DriftScript -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Drift Script</Label> <ScriptBlock> if ($_.DriftScript.Length -gt 83) { $_.DriftScript.Substring(0, 80) + "..." } else { $_.DriftScript } </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.DriftStatus -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Drift Status</Label> <ScriptBlock> $_.DriftStatus </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.SnapshotPackageBytes -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Snapshot Package</Label> <ScriptBlock> "Snapshot" </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.PreReleaseMigrationLogState -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Pre-State</Label> <ScriptBlock> "Migration Log State" </ScriptBlock> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> </ViewDefinitions> </Configuration> <!-- SIG # Begin signature block --> <!-- MIIOOAYJKoZIhvcNAQcCoIIOKTCCDiUCAQExDzANBglghkgBZQMEAgEFADB5Bgor --> <!-- BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG --> <!-- KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCC9fo4b/RoWxDHD --> <!-- wnWftVmxXBTL+aszvrko03MW83989qCCC0kwggVhMIIESaADAgECAhEAmmCfmKmb --> <!-- wplsh+jmCyt8njANBgkqhkiG9w0BAQsFADB9MQswCQYDVQQGEwJHQjEbMBkGA1UE --> <!-- CBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYDVQQHEwdTYWxmb3JkMRowGAYDVQQK --> <!-- ExFDT01PRE8gQ0EgTGltaXRlZDEjMCEGA1UEAxMaQ09NT0RPIFJTQSBDb2RlIFNp --> <!-- Z25pbmcgQ0EwHhcNMTgxMjA2MDAwMDAwWhcNMjMxMjA2MjM1OTU5WjCByTELMAkG --> <!-- A1UEBhMCR0IxEDAOBgNVBBEMB0NCNCAwV1oxFzAVBgNVBAgMDkNhbWJyaWRnZXNo --> <!-- aXJlMRIwEAYDVQQHDAlDYW1icmlkZ2UxIDAeBgNVBAkMF0NhbWJyaWRnZSBCdXNp --> <!-- bmVzcyBQYXJrMRkwFwYDVQQJDBBOZXduaGFtIEhvdXNlIDEyMR4wHAYDVQQKDBVS --> <!-- ZWQgR2F0ZSBTb2Z0d2FyZSBMdGQxHjAcBgNVBAMMFVJlZCBHYXRlIFNvZnR3YXJl --> <!-- IEx0ZDCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAOH+F3Sk50JSwoTB --> <!-- LCsQ9v1SI9Onihjw125qfKGkkG1JsZLes422aIKa5DMgfzzB92KJIB5XS4iV9p9P --> <!-- x2VoUgR9V+BGNWNWogvaZoC7+nA9081CctV3eyRW1qnFPCWHucC65cdVe9blvkZl --> <!-- VYjR3gg6hzY+otksyrChYzcpDEB4R7F9rTiyFJaXUp5JBxoPZbA60yQ8hiin7XPf --> <!-- 6AHxJMXkvozyWxUqWHFAS1OJftYoCdUyirn+fdqERTSZEgUbXrrAZ/9nSo0uAQ78 --> <!-- tgIixIP3ckkkwevCOB4nbBnBkyj7HVRLJeRrBC7J0ny2eAzzNSkYWSePWg02YGGP --> <!-- gvQxJikCAwEAAaOCAY0wggGJMB8GA1UdIwQYMBaAFCmRYP+KTfrr+aZquM/55ku9 --> <!-- Sc4SMB0GA1UdDgQWBBRww05Z3jeA8BStihsb0U4vNQSbDjAOBgNVHQ8BAf8EBAMC --> <!-- B4AwDAYDVR0TAQH/BAIwADATBgNVHSUEDDAKBggrBgEFBQcDAzARBglghkgBhvhC --> <!-- AQEEBAMCBBAwRgYDVR0gBD8wPTA7BgwrBgEEAbIxAQIBAwIwKzApBggrBgEFBQcC --> <!-- ARYdaHR0cHM6Ly9zZWN1cmUuY29tb2RvLm5ldC9DUFMwQwYDVR0fBDwwOjA4oDag --> <!-- NIYyaHR0cDovL2NybC5jb21vZG9jYS5jb20vQ09NT0RPUlNBQ29kZVNpZ25pbmdD --> <!-- QS5jcmwwdAYIKwYBBQUHAQEEaDBmMD4GCCsGAQUFBzAChjJodHRwOi8vY3J0LmNv --> <!-- bW9kb2NhLmNvbS9DT01PRE9SU0FDb2RlU2lnbmluZ0NBLmNydDAkBggrBgEFBQcw --> <!-- AYYYaHR0cDovL29jc3AuY29tb2RvY2EuY29tMA0GCSqGSIb3DQEBCwUAA4IBAQCj --> <!-- oKBTtQs6lykn3yOKEJ4ogHpLDo+/LoM8x6LJJa0CbAOUTofI055B8PCuSq67VVGO --> <!-- 2mQaysR5Juu17v4lEFKF3xmpa1dERYhReFAzhGLOnxhA4hIRABIQoB5Hhai8I81t --> <!-- ccCo7GMOGKOR7v9/8LOv0Z0QCC7VKmWJFjloX3JnRu61XyPA4gp1REEfIwkOWllF --> <!-- 7haTUFN9LmOjrCTyCBNvCiBGDtzR3so2hIO0QVRDN845ZGFHxjYbC12vzE1gdFWx --> <!-- h3Wo6cdkBUNZ101aDuuPQbHvoypVDI2MMj6/yp7sD+qV3EW30Fslwv9YYZzgiiw8 --> <!-- nYMGoukRYaYXw84xcmfiMIIF4DCCA8igAwIBAgIQLnyHzA6TSlL+lP0ct800rzAN --> <!-- BgkqhkiG9w0BAQwFADCBhTELMAkGA1UEBhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIg --> <!-- TWFuY2hlc3RlcjEQMA4GA1UEBxMHU2FsZm9yZDEaMBgGA1UEChMRQ09NT0RPIENB --> <!-- IExpbWl0ZWQxKzApBgNVBAMTIkNPTU9ETyBSU0EgQ2VydGlmaWNhdGlvbiBBdXRo --> <!-- b3JpdHkwHhcNMTMwNTA5MDAwMDAwWhcNMjgwNTA4MjM1OTU5WjB9MQswCQYDVQQG --> <!-- EwJHQjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYDVQQHEwdTYWxm --> <!-- b3JkMRowGAYDVQQKExFDT01PRE8gQ0EgTGltaXRlZDEjMCEGA1UEAxMaQ09NT0RP --> <!-- IFJTQSBDb2RlIFNpZ25pbmcgQ0EwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEK --> <!-- AoIBAQCmmJBjd5E0f4rR3elnMRHrzB79MR2zuWJXP5O8W+OfHiQyESdrvFGRp8+e --> <!-- niWzX4GoGA8dHiAwDvthe4YJs+P9omidHCydv3Lj5HWg5TUjjsmK7hoMZMfYQqF7 --> <!-- tVIDSzqwjiNLS2PgIpQ3e9V5kAoUGFEs5v7BEvAcP2FhCoyi3PbDMKrNKBh1SMF5 --> <!-- WgjNu4xVjPfUdpA6M0ZQc5hc9IVKaw+A3V7Wvf2pL8Al9fl4141fEMJEVTyQPDFG --> <!-- y3CuB6kK46/BAW+QGiPiXzjbxghdR7ODQfAuADcUuRKqeZJSzYcPe9hiKaR+ML0b --> <!-- tYxytEjy4+gh+V5MYnmLAgaff9ULAgMBAAGjggFRMIIBTTAfBgNVHSMEGDAWgBS7 --> <!-- r34CPfqm8TyEjq3uOJjs2TIy1DAdBgNVHQ4EFgQUKZFg/4pN+uv5pmq4z/nmS71J --> <!-- zhIwDgYDVR0PAQH/BAQDAgGGMBIGA1UdEwEB/wQIMAYBAf8CAQAwEwYDVR0lBAww --> <!-- CgYIKwYBBQUHAwMwEQYDVR0gBAowCDAGBgRVHSAAMEwGA1UdHwRFMEMwQaA/oD2G --> <!-- O2h0dHA6Ly9jcmwuY29tb2RvY2EuY29tL0NPTU9ET1JTQUNlcnRpZmljYXRpb25B --> <!-- dXRob3JpdHkuY3JsMHEGCCsGAQUFBwEBBGUwYzA7BggrBgEFBQcwAoYvaHR0cDov --> <!-- L2NydC5jb21vZG9jYS5jb20vQ09NT0RPUlNBQWRkVHJ1c3RDQS5jcnQwJAYIKwYB --> <!-- BQUHMAGGGGh0dHA6Ly9vY3NwLmNvbW9kb2NhLmNvbTANBgkqhkiG9w0BAQwFAAOC --> <!-- AgEAAj8COcPu+Mo7id4MbU2x8U6ST6/COCwEzMVjEasJY6+rotcCP8xvGcM91hoI --> <!-- lP8l2KmIpysQGuCbsQciGlEcOtTh6Qm/5iR0rx57FjFuI+9UUS1SAuJ1CAVM8bdR --> <!-- 4VEAxof2bO4QRHZXavHfWGshqknUfDdOvf+2dVRAGDZXZxHNTwLk/vPa/HUX2+y3 --> <!-- 92UJI0kfQ1eD6n4gd2HITfK7ZU2o94VFB696aSdlkClAi997OlE5jKgfcHmtbUIg --> <!-- os8MbAOMTM1zB5TnWo46BLqioXwfy2M6FafUFRunUkcyqfS/ZEfRqh9TTjIwc8Jv --> <!-- t3iCnVz/RrtrIh2IC/gbqjSm/Iz13X9ljIwxVzHQNuxHoc/Li6jvHBhYxQZ3ykub --> <!-- Ua9MCEp6j+KjUuKOjswm5LLY5TjCqO3GgZw1a6lYYUoKl7RLQrZVnb6Z53BtWfht --> <!-- Kgx/GWBfDJqIbDCsUgmQFhv/K53b0CDKieoofjKOGd97SDMe12X4rsn4gxSTdn1k --> <!-- 0I7OvjV9/3IxTZ+evR5sL6iPDAZQ+4wns3bJ9ObXwzTijIchhmH+v1V04SF3Awpo --> <!-- bLvkyanmz1kl63zsRQ55ZmjoIs2475iFTZYRPAmK0H+8KCgT+2rKVI2SXM3CZZgG --> <!-- ns5IW9S1N5NGQXwH3c/6Q++6Z2H/fUnguzB9XIDj5hY5S6cxggJFMIICQQIBATCB --> <!-- kjB9MQswCQYDVQQGEwJHQjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVzdGVyMRAw --> <!-- DgYDVQQHEwdTYWxmb3JkMRowGAYDVQQKExFDT01PRE8gQ0EgTGltaXRlZDEjMCEG --> <!-- A1UEAxMaQ09NT0RPIFJTQSBDb2RlIFNpZ25pbmcgQ0ECEQCaYJ+YqZvCmWyH6OYL --> <!-- K3yeMA0GCWCGSAFlAwQCAQUAoIGEMBgGCisGAQQBgjcCAQwxCjAIoAKAAKECgAAw --> <!-- GQYJKoZIhvcNAQkDMQwGCisGAQQBgjcCAQQwHAYKKwYBBAGCNwIBCzEOMAwGCisG --> <!-- AQQBgjcCARUwLwYJKoZIhvcNAQkEMSIEID3M+ql3vLHkcUBoJg0TGRMkR+fRhauJ --> <!-- VDsCOBzHQUKmMA0GCSqGSIb3DQEBAQUABIIBAIF5xM0oh9q5hb0fQ3vvbqqtDoCR --> <!-- 8yow51Lx7PXQvc2bFsR+8kcgAIICw6n+w5ghuTpictBRq9VwpmaVr4YGvGTi15TQ --> <!-- HpR1MZc/sEPq6iEItfIgbWXh6oBl1d8IysikFf0dYhBuOO0laESWV8X6F3gMMAI5 --> <!-- cW/mMYD1VDx+OORf7fgxYClUu96AuoXqO3s1bhA3JjWCvO7z0O0igVpZMmmg0gCB --> <!-- yZ4BCCIRSAIb/K15XKw9rWeEsb1soVKi4X6RoMtUczHYdPSqRUIyuwldJaee8rTJ --> <!-- GzWgZopJRTxgV4vO7gUOLvOc8qz5efb6TnMCpMh8jyAxhyWLqHig8m2ABbI= --> <!-- SIG # End signature block --> |