How to resolve from command line

Twisty · March 23, 2020 3:19PM

Hi,

I wonder how to resolve issues from command line. When using Schema Compare for Oracle UI, when creating script we can specify values for not null columns. How can we do it in command line?

Here's an example :

</code><div>Issue:       InsertNotNull: test.table.column1
Resolutions: AllowNull,SpecifyValue,Ignore
Resolution:  Ignore
             Deployment could fail; you might have to edit the script before running it

</div></pre><div>What would be the syntax in command line?<br></div></div><div><br><pre class="CodeBlock"><code><div>C:\"Program Files\Red Gate\Schema Compare for Oracle 5\sco.exe" `
...
/resolve:"InsertNotNull: test.table.column1":"SpecifyValue:someText"<br></div>

Sergio R · March 24, 2020 7:14PM

The only option that you can use to resolve that issue in the command line tool is AllowNull

Besides using the UI, you can also use Redgate Change Control, you'd need to edit the scripts in a similar way but you'd be able to deploy them automatically using Flyway.
https://documentation.red-gate.com/dso/redgate-change-control

Twisty · March 25, 2020 12:58AM

Thanks for the answer, we had a similar approach where our pipeline failed in those situation. A dev would look at the log output and create pre scripts to run with flyway before doing a schema compare. Is the /resolve will evolve with those kind of dynamic adjustement in the near future? Is there somewhere I can create a ticket to have this kind of feature?

David Atkinson · March 25, 2020 10:52AM

@Twisty - Our recommendation here is to use migrations-based deployments, rather than state-based deployments. The ability to dynamically calculate the right script has limitations (one of which you've hit) and therefore adopting a solution where you can customize the scripts as you want them allows all such issues to be resolved. Is there a reason why you wouldn't be able to use migrations-based deployments?

Twisty · April 16, 2020 1:21AM

In our case I don't think we can apply migrations-based deployment, but we did find a solution to solve our issues, thanks for the answer

David Atkinson · April 16, 2020 8:21AM

@Twisty - great to hear. What was the solution you ended up using?

How to resolve from command line

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk