Tell SQLcl to set liquibaseSchemaName for databasechangelog table

General Discussion
1

Hi!

What I want to achieve is to tell SQLcl to look for databasechangelog table in a provided schema and not the current one. In a liquibase I can set liquibaseSchemaName property for it. And maybe someone is familiar how to do the same when using SQLcl?

If I run lb update with -debug key I can see the following list of parameters:

changelog=stat_int/main.yaml
command=update
context=
count=
debug=true
emit_schema=false
enable=true
fail=false
filename=
grants=false
help=false
isSqlCl=true
label=
log=false
name=
password=
privs=true
replace=false
report=true
runalways=false
runonchange=false
silent=false
synonyms=false
type=
url=
user=

Maybe some of these parameters would work?

2

Hi @krow7

I’ve never really tried using SQLcl. As I’m new to it, please bear with my silly questions here :slight_smile:

Did you try using -liquibaseSchemaName itself with SQLcl? If yes did you get unknown attribute or any other error for this?

Thanks!
Rakhi Agrawal

3

Hi @rakhi !

Feel free to ask as much as you want :slight_smile:

SQLcl is a new Command Line Interface for interacting with Oracle Database. You can find more information on SQLcl on official Oracle website.

Yes, I’ve tried to pass -liquibaseSchemaName but looks like SQLcl limits number of passed to liquibase core arguments to the ones I’ve mentioned in a previous post. I’ve reached out to Jeff Smith, one of members developing SQLcl product. I will share results if any.

1 Like
4

Thanks @krow7 . Will keep an eye for the findings!

5

Hi everyone,
I arrived at the same issue. Any updates @krow7 ?