Egalware/C2P
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
C2P/C2P_compare_dev2prod.scmp
T
Samuele E. Locatelli 9a5a6594dc aggiunta progetto DB x C2P con install db locale
2014-02-18 18:01:35 +01:00

512 lines
20 KiB
XML
Raw Permalink Blame History

<?xml version="1.0" encoding="utf-8"?>
<SchemaComparison>
<Version>10</Version>
<SourceModelProvider>
<ProjectBasedModelProvider>
<ProjectGuid>{84db66e4-9663-47f7-9dd1-3cb562629ff5}</ProjectGuid>
<Name>C2P_Project</Name>
</ProjectBasedModelProvider>
</SourceModelProvider>
<TargetModelProvider>
<ConnectionBasedModelProvider>
<ConnectionString>Data Source=10.74.82.217\SQL2008R2;Initial Catalog=Proxima_C2P_prod;Persist Security Info=True;User ID=sa;Pooling=False</ConnectionString>
</ConnectionBasedModelProvider>
</TargetModelProvider>
<SchemaCompareSettingsService>
<SchemaCompareSettingsService>
<PropertyElementName>
<Name>Version</Name>
<Value>1</Value>
</PropertyElementName>
</SchemaCompareSettingsService>
<ConfigurationOptionsElement>
<PropertyElementName>
<Name>PlanGenerationType</Name>
<Value>SqlDeploymentOptions</Value>
</PropertyElementName>
<PropertyElementName>
<Name>AllowExistingModelErrors</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>AllowIncompatiblePlatform</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>BackupDatabaseBeforeChanges</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>BlockOnPossibleDataLoss</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>BlockWhenDriftDetected</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>CompareUsingTargetCollation</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>CommentOutSetVarDeclarations</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>CreateNewDatabase</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>DeployDatabaseInSingleUserMode</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>DisableAndReenableDdlTriggers</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>DoNotAlterChangeDataCaptureObjects</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>DoNotAlterReplicatedObjects</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>DropConstraintsNotInSource</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>DropDmlTriggersNotInSource</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>DropExtendedPropertiesNotInSource</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>DropIndexesNotInSource</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>DropPermissionsNotInSource</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>DropObjectsNotInSource</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>DropRoleMembersNotInSource</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>GenerateSmartDefaults</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreDdlTriggerOrder</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreDdlTriggerState</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreObjectPlacementOnPartitionScheme</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreAuthorizer</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreDefaultSchema</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreRouteLifetime</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreCryptographicProviderFilePath</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreComments</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreWhitespace</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreKeywordCasing</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreSemicolonBetweenStatements</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnorePartitionSchemes</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreWithNocheckOnCheckConstraints</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreWithNocheckOnForeignKeys</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreIdentitySeed</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreIncrement</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreFillFactor</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreIndexPadding</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreColumnCollation</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreLockHintsOnIndexes</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreTableOptions</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreIndexOptions</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreDmlTriggerOrder</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreDmlTriggerState</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreAnsiNulls</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreQuotedIdentifiers</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreUserSettingsObjects</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreFilegroupPlacement</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreFullTextCatalogFilePath</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreFileAndLogFilePath</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreLoginSids</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreNotForReplication</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IgnoreFileSize</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IncludeCompositeObjects</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>IncludeTransactionalScripts</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>NoAlterStatementsToChangeCLRTypes</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>PopulateFilesOnFileGroups</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>RegisterDataTierApplication</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>ScriptDatabaseCollation</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>ScriptDatabaseCompatibility</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>ScriptDatabaseOptions</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>ScriptDeployStateChecks</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>ScriptFileSize</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>ScriptNewConstraintValidation</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>ScriptRefreshModule</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>TargetConnectionString</Name>
<Value>Integrated Security=True;Pooling=False;Connect Timeout=30</Value>
</PropertyElementName>
<PropertyElementName>
<Name>TreatVerificationErrorsAsWarnings</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>UnmodifiableObjectWarnings</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>VerifyCollationCompatibility</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>VerifyDeployment</Name>
<Value>True</Value>
</PropertyElementName>
<PropertyElementName>
<Name>AllowDropBlockingAssemblies</Name>
<Value>False</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlDatabaseOptions</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlErrorMessage</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlLogin</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlServerRoleMembership</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlLinkedServer</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlLinkedServerLogin</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlFile</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlServerDdlTrigger</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlMasterKey</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlCredential</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlRoute</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlEventNotification</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlEndpoint</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlDatabaseAuditSpecification</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlServerAudit</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlServerAuditSpecification</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlCryptographicProvider</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlDatabaseEncryptionKey</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlEventSession</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlUserDefinedServerRole</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
<PropertyElementName>
<Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlAssemblyFile</Name>
<Value>ExcludedType</Value>
</PropertyElementName>
</ConfigurationOptionsElement>
</SchemaCompareSettingsService>
<SchemaCompareViewSettings>
<GroupBy>2</GroupBy>
<ZoomLevel>100</ZoomLevel>
<Filter>Equals_Objects,Not_Supported_Deploy</Filter>
</SchemaCompareViewSettings>
<ExcludedSourceElements>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlProcedure, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>voc</Name>
<Name>stp_insNewLemma</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSubroutineParameter, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>voc</Name>
<Name>stp_insNewLemma</Name>
<Name>@lemma</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSubroutineParameter, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>voc</Name>
<Name>stp_insNewLemma</Name>
<Name>@traduzione</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlProcedure, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>dbo</Name>
<Name>stp_VSItem_SearchLike</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSubroutineParameter, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>dbo</Name>
<Name>stp_VSItem_SearchLike</Name>
<Name>@value</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlProcedure, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>dbo</Name>
<Name>stp_esplodiVocab</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlExtendedProperty, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>SqlView</Name>
<Name>dbo</Name>
<Name>v_selItems</Name>
<Name>MS_DiagramPane1</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlExtendedProperty, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>SqlView</Name>
<Name>dbo</Name>
<Name>v_selItems</Name>
<Name>MS_DiagramPaneCount</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlView, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>dbo</Name>
<Name>v_selItems</Name>
</SelectedItem>
</ExcludedSourceElements>
<ExcludedTargetElements>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlProcedure, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>tmp</Name>
<Name>importClientsRaw</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSubroutineParameter, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>tmp</Name>
<Name>importClientsRaw</Name>
<Name>@fileType</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlProcedure, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>tmp</Name>
<Name>importDiesGroupRaw</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSubroutineParameter, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>tmp</Name>
<Name>importDiesGroupRaw</Name>
<Name>@fileType</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlProcedure, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>tmp</Name>
<Name>importDiesRaw</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSubroutineParameter, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>tmp</Name>
<Name>importDiesRaw</Name>
<Name>@fileType</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlProcedure, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>tmp</Name>
<Name>importItemsRaw</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSubroutineParameter, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>tmp</Name>
<Name>importItemsRaw</Name>
<Name>@fileType</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlProcedure, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>tmp</Name>
<Name>importPackagRaw</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSubroutineParameter, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>tmp</Name>
<Name>importPackagRaw</Name>
<Name>@fileType</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlProcedure, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>tmp</Name>
<Name>importProductionLogRaw</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSubroutineParameter, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>tmp</Name>
<Name>importProductionLogRaw</Name>
<Name>@fileType</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlProcedure, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>tmp</Name>
<Name>importTranspCostRaw</Name>
</SelectedItem>
<SelectedItem Type="Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSubroutineParameter, Microsoft.Data.Tools.Schema.Sql, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<Name>tmp</Name>
<Name>importTranspCostRaw</Name>
<Name>@fileType</Name>
</SelectedItem>
</ExcludedTargetElements>
</SchemaComparison>
Reference in New Issue View Git Blame Copy Permalink