Questions tagged [liquibase]

Liquibase is an open source, database-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes are stored in a human readable yet trackable form and checked into source control.

Liquibase Supports:

  • Extensibility
  • Merging changes from multiple developers
  • Code branches
  • Multiple Databases
  • Managing production data as well as various test datasets
  • Cluster-safe database upgrades
  • Automated updates or generation of SQL scripts that can be approved and applied by a DBA
  • Update rollbacks
  • Database ”diff“s
  • Generating starting change logs from existing databases
  • Generating database change documentation

Resources

3764 questions
1
vote
2 answers

Do we have any supported liquibase plugins for Jenkins?

We are using Liquibase 3.8.5 version. Our requirement is to execute Liquibase script in Jenkins however we are not able to find out any Liquibase plugin in Jenkins. Please let us know how to fix issue. Thanks in advance.
Rohan
  • 29
  • 1
  • 3
1
vote
1 answer

liquibase sqlFile complains that "File does not exist"

So, a while back I moved all of our database functions and view to individual files for better change control. Today, I deleted a function and therefore I deleted the file for that function. However, the original changeLog from 2019.Q2.R1 still…
1
vote
1 answer

liquibase-maven-plugin log level

I am using liquibase-maven-plugin version 3.8.4 under maven version 3.0.1 and I'm encountering issues with logging: running mvn liquibase:update spits out hundreds and hundreds of lines of fine debugging info, like 18:09:38.241 [main] DEBUG…
12345ieee
  • 420
  • 1
  • 4
  • 15
1
vote
1 answer

How to update a existent database using JHipster and Liquibase?

Jhipster creates a initial project structure for us, but normally there changes in an active application, like a new entity, a new relationship or any field modification. All changes modify the initial database. What is the recommended way to modify…
renanvm
  • 208
  • 3
  • 16
1
vote
1 answer

Is there a way to actually execute a DDL update with liquibase-maven-plugin?

I'm new to liquibase and I am wondering whether it is possible to actually execute a changeset. update/updateSQL goal seem to simply generate a SQL file with all SQL commands (https://www.liquibase.org/documentation/maven/maven_updatesql.html) And…
jpmsnewbie
  • 115
  • 7
1
vote
1 answer

Can we monitor newly added data inside database table using Liquibase?

I want to monitor newly added data inside database table using Liquibase. I have found out that we can do Create, Insert, update, delete, rollback types of operations on table but I not sure whether we can perform read operation to see actual data.
Harsh
  • 47
  • 2
  • 9
1
vote
2 answers

Liquibase preconditions to all changelog file in sql

I would like to run a SQL precondition checking for each changeSet in my SQL changeLogFile. It is actually a precondition on the changeLog itself Here is an extract of it : --liquibase formatted sql --preconditions onFail:HALT…
Cedric C
  • 11
  • 2
1
vote
4 answers

Running mvn liquibase:updateSQL on a specific changeSet

Somebody who's a more seasoned maven user can probably help me out here: how do I pass in "optional parameters" to liquibase when running it as a maven goal? I want to pass in "changesToApply", see…
PapaFreud
  • 3,636
  • 4
  • 34
  • 45
1
vote
1 answer

How do I run a Liquibase changeLogFile from my classpath

I have a Spring Boot application that is configured to run Liquibase. I'm trying to set up a separate project that will be used as the database management project. It will store all of liquibase.properties files for different databases. My…
bheussler
  • 1,406
  • 2
  • 15
  • 18
1
vote
1 answer

CLI command executes from terminal but not Python

I am using Liquibase (http://www.liquibase.org) to try and diff two databases. Liquibase is installed and running fine from CLI, however when I try to fun the same command from Python 3.7 using subprocess and shlex i can FileNotFoundError: [Errno 2]…
kravb
  • 417
  • 4
  • 16
1
vote
2 answers

Liquibase doesn't update in-memory h2 database

I set up a simple spring-boot-application, and wanted to include liquibase for database migrations. I defined a master.xml, which consists of a single reference to another file. This file defines a changeset for creating a table with the name test.…
Sali Ke
  • 11
  • 1
  • 4
1
vote
1 answer

Multiple apps with liquibase connected to one database

We have multiple spring boot applications (microservices) which are connecting to one database. Each application has custom db schema, for instance App A is connecting to schema_a, App B is connecting to schema_b, and so on. These applications which…
Denis Stephanov
  • 4,563
  • 24
  • 78
  • 174
1
vote
1 answer

liquibase update showing "ORA-12514, TNS:listener does not currently know of service requested in connect descriptor" Error

I am trying to Creating New Liquibase Projects with Oracle 12c database.My oracle database is located on a remote server.This is my changelog for my project and it is saved as dbchangelog.xml on my machine where Liquibase is running
Pratheesh
  • 565
  • 4
  • 19
1
vote
1 answer

How to mark ran on all change sets of a changelog using a single pre condition?

I am using liquibase v3.6.3 with postgresql v9.4. I have a changelog file with over 40 change sets. All of these changes (which consists of adding tables, foreign keys, etc.) have a single condition to run, which is to check if a specific table…
Ernani
  • 319
  • 1
  • 4
  • 18
1
vote
0 answers

Cannot find database driver: net.snowflake.client.jdbc.SnowflakeDriver

I was following getting started with liquibase on snowflake to set up Snowflake db connection to liquibase, but with the following liquibase.properties file: driver: net.snowflake.client.jdbc.SnowflakeDriver classpath:…
Anuj Kumar
  • 130
  • 1
  • 9
1 2 3
99
100