Skip to Main Content
Forums

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLcl 22.3 Liquibase - how to get a changeset

hermanmolMar 10 2023

Hi,

Maybe a silly question: how to get a proper change log and set for next day-to-day scenario?

  1. get a baseline ddl (or xml) of a schema using SQLcl Liquibase (generate-changelog? generate-schema? …?)
  2. add a column to a table in that schema using
  3. get the proper change log and set using SQLcl Liquibase to pass the upgrade SQL to the DBA (changelog-sync-sql? diff-changeLog? generate-changelog? update-sql? ...?)

I have been trying for several hours, watched numeous YouTubes including CI/CD in oracle https://youtu.be/P3La7ig37CU but I just cannot get this basic flow…

Herman

I'm on Oracle 12.2 running on RHEL in docker on a Virtual Box, connecting from Windows 10 Pro.
This post has been answered by hermanmol on Mar 16 2023
Jump to Answer
Comments
Post Details
Added on Mar 10 2023
#installation
7 comments
933 views
2 mentions