SQLcl 22.3 was released while I was on vacation…how dare they!
This blog is coming a few days later than normal, you have my sincerest apologies.
- a ton of bug fixes
- a new command interface
- updated Liquibase feature
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 –
-ex is shorthand for -example
If I ask for help just on ‘dp’ itself, I get this –
These changes were implemented on a few command including datapump, migrateadvisor, and 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.
SQLcl’s Liquibase Docs got a major update as well
You probably want to start here, the supported commands.