Тёмный

Demo: Using SQLcl and Liquibase to version your Oracle Database 

Jeff Smith
Подписаться 9 тыс.
Просмотров 4,9 тыс.
50% 1

I'll show you in 5 minutes you can use the friendly SQLcl command line interface to generate a Liquibase changeset for your Oracle Schema, how to update a new schema with that changeset, and finally how you can use the sqlFile feature to do things like INSERT data to your tables.
Oracle SQLcl is a modern, friendly command line interface for Oracle Database. In the Summer of 2019, we introduced support for Liquibase - and also enhanced its Oracle support. We generate the changelogs for you, figure out the right order to apply those changes, and even automatically handle rollback for you.

Наука

Опубликовано:

 

23 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 13   
@AlexLimaYYC
@AlexLimaYYC 4 года назад
Hi Jeff, I do a lot of migrations and upgrades where we need to create the schema ahead of the data migration, would you use this process to do that or something different? Currently i have a exp/imp and other scripts process, but if there is something more efficient this days i would be happy to try.
@JeffSmiththat
@JeffSmiththat 4 года назад
Liquibase doesn't support deploying the USER account itself, I think you'd have to write a custom changeset of type sqlFile - and just have the CREATE USER xyz in that.
@rdi5
@rdi5 2 года назад
Hello Jeff, what is your opinion about using sqlcl in a production environment and using it with cron jobs through crontab to execute shell scripts that currently run sqlplus scripts? Is sqlcl a tool that could be used reliably in that way? Some of the format features could come in handy for those type of jobs.
@JeffSmiththat
@JeffSmiththat 2 года назад
It's designed and intended to be used in product environments for product workloads and production tasks - GO FOR IT!
@mohamedheba173
@mohamedheba173 11 месяцев назад
Hi Jeff, I am using lb generate-schema -split to extract all changes related to a schema in a source oracle DB. and before running this command I set DDL off for STORAGE, PARTITIONING, SEGMENT_ATTRIBUTES, TABLESPACE, EMIT_SCHEMA and SIZE_BYTE_KEYWORD. after export finished i find that indexes xml file contains all information related storage and all other INDEX_ATTRIBUTES. the problem is when i try to update destination schema "In a different DB" i receive error "ORA-02203: INITIAL storage options not allowed". I notices when I use command LB GEO -OBN INDEX_NAME -OBT INDEX, xml generate without storage attributes and the update complete successfully. is there any option to avoid storage and index attribute in generate schema command?
@JeffSmiththat
@JeffSmiththat 11 месяцев назад
I'm currently hunting down this bug, for some reason the DDL settings aren't equally being honored between generate-schema and generate-object. Your expectation of the behavior is correct, we're not doing something right. Stay tuned.
@mohamedheba173
@mohamedheba173 11 месяцев назад
@@JeffSmiththat Thank you for your reply, I was using sqlcl version 23.2 when i found this issue, i downgraded to version 22 but I can still find the same issue. is there any recommended version i can use?
@JeffSmiththat
@JeffSmiththat 8 месяцев назад
Turns out this is how it's supposed to work, when you do the UPDATE, set your sqlformat settings, and it'll honor those. See this blog post www.thatjeffsmith.com/archive/2023/10/sqlcl-liquibase-physical-properties-for-oracle-tables/ We're looking at making this work in either direction for a future update.
@mohamedheba173
@mohamedheba173 8 месяцев назад
@@JeffSmiththatThanks a lot for your reply. Yes, I used to set the sqlformat during UPDATE but SQLcl still ignoring it and raise errors.
@JeffSmiththat
@JeffSmiththat 8 месяцев назад
@@mohamedheba173 I need an example and more details Jeff.d.smith@oracle.com
Далее
Version based database migration with Liquibase
10:47
НОВАЯ ПАСХАЛКА В ЯНДЕКСЕ
00:20
Просмотров 1,4 млн
Command Line SQL with SQLcl
44:51
Просмотров 10 тыс.
I've been using Redis wrong this whole time...
20:53
Просмотров 341 тыс.
How to Integrate Liquibase With Jenkins
8:52
Просмотров 9 тыс.
Здесь упор в процессор
18:02
Просмотров 385 тыс.
iPhone 15 Pro в реальной жизни
24:07
Просмотров 424 тыс.