8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for SQLcl : Automating Your SQL and PL/SQL Deployments using the SQLcl implementation of Liquibase


Anonymous said...

What if 2 people change same schema object, like packages? Its not uncommon. Its easy to miss changes here. Its very important to have a "maintainer" to manage schema and code changes so that we have changelogs in order. And yes, i don't like liquibase tag for schema change either! I have a hunch it does not work for complex table creation, like index or partitioned table.

Tim... said...

Hi.

Their changes are separate events. They will be merged into the relevant branch separately, or as a single pull request, if it is safe to pull both commits I guess. Either way, their change will only be included in the master change log when they are happy for it to be applied to the relevant environment. As a result, the change log is the serialisation of this.

As I mention in the article, this needs discipline and process in place to work. It's not magic. It's also why I suggest fix-forward. If something goes in that breaks stuff, you have to "load the old version". That is a new commit, putting back the old version and applying it. The "reversion" is a new version.

Deployment pipelines *always* have to consider how you handle multiple people working on the same thing. Databases are no different in this respect. That's the fun. :)

Cheers

Tim...

Michael said...

Thanks for the summary, Tim. Agree about tracking code in a VCS - we store all functions/procs/packages in separate files with runOnChange:true to keep things simple.
One problem: I'm trying genschema (or genobject) and I can't get it to suppress the schema in either 19.4 or 20.2. The -emit_schema seems stuck on, and doesn't have a negative version. Any ideas?

Tim... said...

Hi.

Sounds like a bug. Best bet is to ask a question about it on the ORDS community site. The ORDS PM and the developers will see it there.

https://community.oracle.com/community/groundbreakers/database/developer-tools/sql_developer/sqlcl

Cheers

Tim...

Anonymous said...

export apex application in sqlcl 20.2 broken, details here
https://community.oracle.com/thread/4343582

from: skutz-Oracle : 19.08.2020 15:29

I had a bug here sorry. You were spot on it's missing the runOracleSCript after the no:
So in the XML the line after

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.