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

10raw10raw Posts: 20 Bronze 1
edited August 3, 2018 4:00PM in SQL Change Automation

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

Answers

Sign In or Register to comment.