Stack Overflow
Stack Overflow

Questions tagged [liquibase-cli]

20 questions
0
votes
0 answers

Liquibase createTable not creating primary Key

I am using MySQL, using Liquibase (Liquibase Version: 4.23.1), I am generating a table in the changeset and in another changeset, I am using precondition to check if the primary key exists and then only insert the record.
shrikant.sharma
  • 203
  • 1
  • 17
  • 37
0
votes
0 answers

Liquibase error IDENTITY_INSERT is set to OFF

I am using Liquibase tool for database migration from one database(MSSQL) to other database(MSSQL). I am able to generate change xml file using generateChangeLog command which has create and insert queries. so far its good. Now when I try to execute…
Sohan Badaya
  • 365
  • 4
  • 15
0
votes
0 answers

Liquibase Upgrade Causes Certain Changesets to Rerun

Upgrading from Liquibase 4.4.2 to 4.23.0 (I know, shame on us for the lag) causes certain changesets to rerun in our existing databases. We then tried all of the versions from 4.23.0 down to 4.19.1 with the same result. Seemingly only changesets…
DDirkson
  • 1
  • 1
0
votes
0 answers

Liquibase best practice to setup for multi Schema/Database repository on different environments

Suppose I have below repo with folder structure with changelog and properties files- projectRepo/ DB_A/changelog.xml DB_B/changelog.xml DB_C/changelog.xml masterChangelog.xml liquibase.properties Above we…
Workonphp
  • 1,635
  • 1
  • 19
  • 21
0
votes
0 answers

LIQUIBASE: CREATE EXTERNAL TABLE cannot run inside a multiple commands statement;

I have a sql file that has multiple CREATE EXTERNAL SCHEMA and CREATE EXTERNAL TABLE statements in it, that I'm trying to execute through Liquibase. This is running against a Redshift database. I'm getting the following error: CREATE EXTERNAL…
Victor Rodriguez
  • 11
  • 2
0
votes
0 answers

Liquibase looks for "db-changelog.xml" file even when the --changeLogFile option refers to the different file

I have observed a very strange behaviour when running Liquibase command (with liquibase.exe tool) from CMD terminal, on Windows. I have a project, that's structured as: my_project |-src |-main |-java |-resources …
Giorgi Tsiklauri
  • 9,715
  • 8
  • 45
  • 66
0
votes
0 answers

Rollback using Spring Boot Application in Liquibase

I have a module in my project which contains Liquibase Changelogs and Changesets The module contains one simple java class which calls Liquibase and executes all the changesets present in the changelog: The java file is something like this: package…
Harsh
  • 11
  • 1
0
votes
1 answer

How to specify tag values in Liquibase changelog/changeset XML?

I have a changelog file which contains multiple changesets like this: .. .. I want…
Harsh
  • 11
  • 1
0
votes
1 answer

Liquibase multi-tenancy: update every schema

I have separate DB schemas (could have used different DB instances) for each tenant to be able to cleanly separate their data. For a single tenant setup the following container configuration is used: ... liquibase: image:…
Balázs Németh
  • 6,222
  • 9
  • 45
  • 60
0
votes
1 answer

Liquibase - Use property value in changeset

I have this changeset
Fábio Pires
  • 89
  • 1
  • 2
  • 10
0
votes
0 answers

Generated changelog has "add" foreign key constraint before "Drop" foreign Key constraint. liquibase jar version : 4.10

I have to upgrade liquibase-core jar from 3.4.2 to version > 4.8 for my application. In our application we are generating the changelog.xml via CLI command. we are using liquibase with Oracle PL/SQl I tried with liquibase-core 4.10 version. But the…
Kumari Priyanka
  • 1
0
votes
0 answers

Unable to create function in Aurora postgres

I am working on a usecase in which I want to use DMS to migrate data from Aurora postgres. To be able to use any user other than the admin users, we need to create some resource in the Aurora postgres database for the DMS to function properly. You…
agrawalramakant
  • 160
  • 1
  • 5
0
votes
1 answer

How to run ":use db" command using liquibase (neo4j plugin)?

I am trying to create a new database in Neo4j and run some cypher queries in that newly created db. I am able to create a new db using the Liquibase update command. But I am unsure how to write a changeset for the command ":use {dbname}". Or is…
SDB
  • 61
  • 1
  • 4
0
votes
1 answer

SQL file with JS code is not working with liquibase

I am using snowflake to manage the database and Currently I am trying to implement liquibase with existing snowflake sql scripts. Some of my sql files contains JS code, for example - create or replace function GetTimeSeries (businessDate…
Bhushan Goel
  • 2,114
  • 3
  • 19
  • 31
0
votes
1 answer

Liquibase Type Mapping MySQL & SQL Server

From command line I let liquibase run in the version 4.19.0. liquibase --changeLogFile=update.xml update where update.xml is a bundle of changelogs: …
Clueless
  • 163
  • 16
1
2