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

Issue running sql compare in Azure Devops Pipeline

Hello,

I am running some pipelines in Azure Devops to deploy changes using flyway, as previous steps there some validations being done using SQL Compare

You must be authenticated before you can continue.

Please run the 'auth' command, or configure personal access tokens (PAT).

 

##[error]Bash exited with code '35'.

Finishing: Pre-Release Schema Snapshot

The command I use inside the yml file to run SQL Compare is as follows:

docker run --rm \
                  --mount type=bind,src=$(Agent.WorkFolder)/QA,dst=/QA \
                  redgate/sqlcompare \
                    /IAgreeToTheEULA \
                    /s1:myservername \
                    /db1:mydatabasename\
                    /userName1:$(FLYWAY_BUILD_USER) \
                    /password1:$(FLYWAY_BUILD_PASSWORD) \
                    /makeSnapshot:/QA/$(PRE_RELEASE_SCHEMA_SNAPSHOT) \
                    /email:$(FLYWAY_EMAIL) \
                    /token:$(FLYWAY_TOKEN)

I reviewed licensing, generated a new PAT and it still throwing the same error.

Thanks in advance!

 

Lauther

 

 

 

Lauther P
0

Add comment

Please sign in to leave a comment.