The AddDatabaseUseStatement Compare option is not supported as it may lead to an unexpected update

10raw

I got this error "The AddDatabaseUseStatement Compare option is not supported as it may lead to an unexpected update of the wrong database." while using DLM automation to create a deployment script using sync and compare option AddDatabaseUseStatement.

I am aware of this and still would like to get the USE statement at the start of script being created so that I can later on manually change it if necessary or I can put the database name some where in script and it will select the right database.

Pleasee let me know if anyone has face this error or forced compareoption to use this option and how to do it.

I appreciate your help.

Thank you

Tianjiao_Li

Hi @10raw

This is unfortunately not supported and I'll contact the development team to update the documentation to make it clearer.

If there is any workaround, I'll let you know.

10raw

Thank you Tianjiao_Li for the response.

Sumanta

Hi @Tianjiao_Li Any updates?

Tianjiao_Li

Hi @Sumanta

I should have an update today or tomorrow. I'll keep here posted.

Tianjiao_Li

Hi @10raw @Sumanta

The development team has confirmed AddDatabaseUseStatement Compare option is not supported as the error message says. 

In term of workaround, you can create a release artifact with the New-DatabaseReleaseArtifact and export it with Export-DatabaseReleaseArtifact. Some examples on this page https://documentation.red-gate.com/display/SCA3/Export-DatabaseReleaseArtifact . Then the script in the release artifact could be changed manually.