Actuall, what I've noticed is that the New-DatabaseRelease / New-DlmDatabaseRelease calls SQLCompare.exe twice and that has "IncludeDepenencis" as a default as well as others.
I see no way to override these even though I'm explicitly passing in some SQL compare options: below is the chunk of extract info from Octopus (apologies for the formatting)
WARNING: 'New-DatabaseConnection' has been renamed 'New-DlmDatabaseConnection'.
WARNING: 'Test-DatabaseConnection' has been renamed 'Test-DlmDatabaseConnection'.
New-DatabaseConnection, SQL Release 1.3.16.1507, Copyright © Red Gate Software Ltd 2014-2016
Test-DatabaseConnection, SQL Release 1.3.16.1507, Copyright © Red Gate Software Ltd 2014-2016
*******************SQL COMPARE OPTIONS***************************
DecryptPost2KEncryptedObjects,IgnoreFillFactor,IgnoreWhiteSpace,IgnoreFileGroups,IgnoreUserProperties,IgnoreWithElementOrder,IgnoreDatabaseAndServerName
WARNING: 'New-DatabaseRelease' has been renamed 'New-DlmDatabaseRelease'.
New-DatabaseRelease, SQL Release 1.3.16.1507, Copyright © Red Gate Software Ltd 2014-2016
VERBOSE: Parameters:
Source: scripts folder 'D:OctopusApplicationsTestCCS.COC.Database9127.6_1dbstate'
Target: database 'CCS' on server '10.51.42.184'
FilterPath: null
IgnoreStaticData: True
SQLCompareOptions:
DecryptPost2KEncryptedObjects,IgnoreFillFactor,IgnoreWhiteSpace,IgnoreFileGroups,IgnoreUserProperties,IgnoreWithElement
Order,IgnoreDatabaseAndServerName
TransactionIsolationLevel: Serializable
IncludeIdenticalsInReport: False
TemporaryDatabaseServer: null
VERBOSE: Using filter in scripts folder 'D:OctopusApplicationsTestCCS.COC.Database9127.6_1dbstate'
Making a scripts folder of database 'CCS' on server '10.51.42.184'.
VERBOSE: Calling: C:Program Files (x86)Red GateDLM Automation Suite 1SCSQLCompare.exe
"/makescripts:C:Userssvc_OctopusDeployAppDataLocalTempSQL Releaseum0zi3ds.hhz" /force
/options:DecryptPost2kEncryptedObjects,IncludeDependencies /OutputWidth:1024 /server1:10.51.42.184 /database1:CCS
/out:"C:Userssvc_OctopusDeployAppDataLocalTempSQL Releasevj5qfzd0.log"
VERBOSE: C:Program Files (x86)Red GateDLM Automation Suite 1SCSQLCompare.exe ended with exit code 0
VERBOSE: SQLCompare.exe completed successfully.
Creating the update script.
VERBOSE: Calling: C:Program Files (x86)Red GateDLM Automation Suite 1SCSQLCompare.exe
"/filter:C:Userssvc_OctopusDeployAppDataLocalTempSQL Releasek30pu2mj.scpf"
/options:ConsiderNextFilegroupInPartitionSchemes,DecryptPost2kEncryptedObjects,DoNotOutputCommentHeader,ForceColumnOrde
r,IgnoreCertificatesAndCryptoKeys,IgnoreDatabaseAndServerName,IgnoreFileGroups,IgnoreFillFactor,IgnoreTSQLT,IgnoreUserP
roperties,IgnoreUsersPermissionsAndRoleMemberships,IgnoreWhiteSpace,IgnoreWithElementOrder,IncludeDependencies,ThrowOnF
ileParseFailed,UseCompatibilityLevel,UseMigrationsV2 /transactionIsolationLevel:SERIALIZABLE
"/scriptFile:C:Userssvc_OctopusDeployAppDataLocalTempSQL Releasepm5djgh0.sql" /showWarnings /include:Identical
"/report:C:Userssvc_OctopusDeployAppDataLocalTempSQL Releasewm41m4rw.xml" /reportType:Xml /force
/OutputWidth:1024 "/scripts1:C:Userssvc_OctopusDeployAppDataLocalTempSQL Releasekogbgz4i.qvj"
"/scripts2:C:Userssvc_OctopusDeployAppDataLocalTempSQL Release ufznnyn.thb"
/out:"C:Userssvc_OctopusDeployAppDataLocalTempSQL Release1mwwkjk0.log"
VERBOSE: C:Program Files (x86)Red GateDLM Automation Suite 1SCSQLCompare.exe ended with exit code 0
VERBOSE: SQLCompare.exe completed successfully.
************************** RedGate.SQLRelease.Compare.Domain.DatabaseRelease **************************** / comments
- Community
- DLM Automation
- Create and Deploy release with options
Actuall, what I've noticed is that the New-DatabaseRelease / New-DlmDatabaseRelease calls SQLCompare.exe twice and that has "IncludeDepenencis" as a default as well as others.
I see no way to overr...
0 votes
