Instantly share code, notes, and snippets.

Embed
What would you like to do?
VERBOSE: [Publish-DbaDacpac][15:35:33] Dac Fx loaded.
VERBOSE: [Publish-DbaDacpac][15:35:33] Connecting to localhost.
VERBOSE: [Publish-DbaDacpac][15:35:33] Executing Deployment.
ComputerName : localhost
InstanceName : MSSQLSERVER
SqlInstance : localhost
Database : WideWorldImportersDW
Dacpac : C:\Users\richardlee\repos\AssistDeploy_WWI_SSIS_Samples\WWI_DW_SSDT\wwi-dw-ssdt\bin\Debug\WideWorldImportersDW.dacpac
PublishXml : C:\Users\richardlee\repos\AssistDeploy_WWI_SSIS_Samples\WWI_DW_SSDT\wwi-dw-ssdt\bin\Debug\WideWorldImportersDW.publish.xml
Result : Initializing deployment (Start)
The object [WideWorldImportersDW] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that
are not in the source' check box.
The object [USERDATA_111BEC19] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that
are not in the source' check box.
The object [WWIDW_MemoryOptimized_Data_27B04BF2] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target
database but that are not in the source' check box.
The object [WideWorldImportersDW_log] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but
that are not in the source' check box.
Initializing deployment (Complete)
Analyzing deployment plan (Start)
Analyzing deployment plan (Complete)
Reporting and scripting deployment plan (Start)
Reporting and scripting deployment plan (Complete)
Updating database (Start)
Update complete.
Updating database (Complete)
DatabaseScriptPath :
MasterDbScriptPath :
DeploymentReport :
DeployOptions : @{AdditionalDeploymentContributors=; AdditionalDeploymentContributorArguments=; AllowDropBlockingAssemblies=False; AllowIncompatiblePlatform=False; BackupDatabaseBeforeChanges=False;
BlockOnPossibleDataLoss=True; BlockWhenDriftDetected=True; CommandTimeout=60; CommentOutSetVarDeclarations=False; CompareUsingTargetCollation=False; CreateNewDatabase=False;
DatabaseSpecification=Microsoft.SqlServer.Dac.DacAzureDatabaseSpecification; DeployDatabaseInSingleUserMode=False; DisableAndReenableDdlTriggers=True;
DoNotAlterChangeDataCaptureObjects=True; DoNotAlterReplicatedObjects=True; DoNotDropObjectTypes=; DropConstraintsNotInSource=True; DropDmlTriggersNotInSource=True;
DropExtendedPropertiesNotInSource=True; DropIndexesNotInSource=True; DropObjectsNotInSource=True; DropPermissionsNotInSource=False; DropRoleMembersNotInSource=False;
DropStatisticsNotInSource=True; GenerateSmartDefaults=False; IgnoreAnsiNulls=True; IgnoreAuthorizer=False; IgnoreColumnCollation=False; IgnoreColumnOrder=False; IgnoreComments=False;
IgnoreCryptographicProviderFilePath=True; IgnoreDdlTriggerOrder=False; IgnoreDdlTriggerState=False; IgnoreDefaultSchema=False; IgnoreDmlTriggerOrder=False; IgnoreDmlTriggerState=False;
IgnoreExtendedProperties=False; IgnoreFileAndLogFilePath=True; IgnoreFilegroupPlacement=True; IgnoreFileSize=True; IgnoreFillFactor=True; IgnoreFullTextCatalogFilePath=True;
IgnoreIdentitySeed=False; IgnoreIncrement=False; IgnoreIndexOptions=False; IgnoreIndexPadding=True; IgnoreKeywordCasing=True; IgnoreLockHintsOnIndexes=False; IgnoreLoginSids=True;
ExcludeObjectTypes=; IgnoreNotForReplication=False; IgnoreObjectPlacementOnPartitionScheme=True; IgnorePartitionSchemes=False; IgnorePermissions=False; IgnoreQuotedIdentifiers=True;
IgnoreRoleMembership=False; IgnoreRouteLifetime=True; IgnoreSemicolonBetweenStatements=True; IgnoreTableOptions=False; IgnoreUserSettingsObjects=False; IgnoreWhitespace=True;
IgnoreWithNocheckOnCheckConstraints=False; IgnoreWithNocheckOnForeignKeys=False; AllowUnsafeRowLevelSecurityDataMovement=False; IncludeCompositeObjects=True;
IncludeTransactionalScripts=False; NoAlterStatementsToChangeClrTypes=False; PopulateFilesOnFileGroups=True; RegisterDataTierApplication=False; RunDeploymentPlanExecutors=False;
ScriptDatabaseCollation=False; ScriptDatabaseCompatibility=False; ScriptDatabaseOptions=True; ScriptDeployStateChecks=False; ScriptFileSize=False; ScriptNewConstraintValidation=True;
ScriptRefreshModule=True; TreatVerificationErrorsAsWarnings=False; UnmodifiableObjectWarnings=True; VerifyCollationCompatibility=True; VerifyDeployment=True}
SqlCmdVariableValues : {}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment