SQLcl 22.3 was released while I was on vacation…how dare they!

Download SQLcl now.

This blog is coming a few days later than normal, you have my sincerest apologies.

The Highlights

For bugs the big ones would be we’re now able to do APEX exports via the APEX command and imports via Liquibase changeSets.

There’s additionally a bunch of parser/insight bugs fixed, which will also go upstream to SQL Developer Web.

New Command Interface

  • Easier to read help pages
  • Standardized parameters/options
  • Easy access to Examples

<command> help <option> -ex

So for say the DataPump command, I can do this –

dp hep import -ex

-ex is shorthand for -example

If I ask for help just on ‘dp’ itself, I get this –

The highlighting is new too.

These changes were implemented on a few command including datapump, migrateadvisor, and liquibase.

Liquibase

This is where most of the work for the last 3 months went. The changes are pretty radical, at least compared to what we offered before.

  • upgraded to Liquibase version 4.15
  • renamed our command and options to match Liquibase’ commands
  • added support for most of the community edition commands and options
  • made it easy/possible to take SQLcl JARs to your existing Liquibase installs/environments
  • fixed a TON of bugs

Yes, I’ll have many more blog posts, videos, and even hands-on labs to discuss Liquibase support in SQLcl, but in the meantime, here’s some slides to chew on.

Before you freak out, yes, we changed up the commands (again), but they’re backwards compatible. We’ll honor the old style, but print a gentle reminder it’s deprecated and you need to update your scripts.

What we have, in a nutshell.

SQLcl’s Liquibase Docs got a major update as well

You probably want to start here, the supported commands.

SQLcl 22.3 Liquibase Docs

It’s a lot.
thatjeffsmith
Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

3 Comments

  1. Avatar

    Hi Jeff,

    I am exploring the possibilities this new version of SQLcl/Liquibase following the example flow as shown on slide 19 of the ppt.

    My subject database schema contains ref-contraints and I run into ORA-02275 errrors when I load the the controller.xml into the new environment using the LB -UPDATE command when the ref_contraint xml’s are processed. The ref-constraints are already generated as part of the create table xml.

    I have tried to solve this by tweaking the DDL generation parameters, but so far without success.

    I could edit the controller.xml file and remove the ref_constraints references, but I presume there must be a more “sophisticated” solution for avoiding these errors.

    Could you give me some hints how to avoid these errors?

    Thnx in advance for your help!

    • thatjeffsmith

      Yeah that is a bug that we fixed in 22.3.1
      Bug 34690393 - LB GENERATES DUPLICATE FOREIGN KEY XML FILE ON GENERATE-SCHEMA AND FAILS TO UPDATE LATER.

Write A Comment