How can we help you today? How can we help you today?

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

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

10raw
0

Comments

5 comments

Sort by
  • 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.
    Tianjiao_Li
    0
  • 10raw
    Thank you Tianjiao_Li for the response.
    10raw
    0
  • Sumanta
    Hi @Tianjiao_Li Any updates?
    Sumanta
    0
  • Tianjiao_Li
    Hi @Sumanta

    I should have an update today or tomorrow. I'll keep here posted.
    Tianjiao_Li
    0
  • 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.
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.