Stack Overflow
Stack Overflow

Questions tagged [liquibase-sql]

113 questions
0
votes
2 answers

How to use different tablespaces for tables and indexes with Liquibase

I am using Liquibase 4.0 and I am executing DB changes using SQL scripts. So I am pointing the SQL files path in the master change log to execute the changes via Liquibase. Now I need to segregate them since I have a requirement to have different…
Sanjib Behera
  • 101
  • 1
  • 13
0
votes
1 answer

Springboot Liquibase AWS Aurora DB Application Startup issue

I have an existing spring boot application and i need to connect to Aurora DB using liquibase and create tables . I have added all the required steps as below but when application is getting deployed not seeing any logs specific to liquibase and the…
Abhi
  • 69
  • 6
0
votes
0 answers

How to Write a Liquibase Script for updating Data value in a column?

I have a table in which i need to alter the data in the column.How do i write the Liquibase script for that? id Cause 1 Invalid Dat 2 Invalid Currency cannot be processed I want to change "Invalid Currency cannot be processed" to "Invalid Currency…
Ayushi Garg
  • 7
  • 4
0
votes
0 answers

Liquibase gradle plugin doesn't seem to work in IntelliJ

I'm trying to integrate Liquibase to my company's application. Our system uses Gradle as the build tool. I'm pretty new to Gradle. I followed the following tutorial. https://dzone.com/articles/managing-your-database-with-liquibase-and-gradle I added…
Amila Fonseka
  • 392
  • 1
  • 5
  • 15
0
votes
3 answers

Liquibase - execute multiple pl/sql packages

Good morninng, I'm create my Liquibase changelog to be able to deploy Oracle object with one click. In my projects we have many packages that we save in the file system as pkb/pks (but we can save them as sql as well) .. I'd like to configure…
clxt1
  • 11
  • 2
0
votes
1 answer

Problem in converting varchar2 column to clob data type in Oracle database

I have one Person table in my database. I am using Oracle database. I have one column ADDRESS which has varchar2 datatype. I want to change datatype of this column from varchar2 to clob. I am doing this change by Liquibase. Here is my change…
Shivam Kumar
  • 69
  • 1
  • 12
0
votes
0 answers

Error in Liquibase IndexExists precondition : Invalid object name ‘SYS.INDEXES’

I am facing this issue while running the pre-condition of indexExists in SQL Server. I have noticed a similar bug reported in liquibase https://liquibase.jira.com/browse/CORE-3107. I don't see it being closed. Is the bug resolved in later versions.…
shubh
  • 9
  • 4
0
votes
1 answer

How to tag a changeset or a changelog file with a tag - webdevops/liquibase

I need to tag a changeset for rollback. Tried this Way 1 docker run --rm -v $(pwd):/liquibase/ -e "LIQUIBASE_URL=jdbc:postgresql://host/dbname" -e "LIQUIBASE_USERNAME=username" -e "LIQUIBASE_PASSWORD=pass" webdevops/liquibase:postgres tag…
Hanisha Arora
  • 1
  • 1
0
votes
1 answer

How to display output of diffChangeLog command on console only?

I am working on Liquibase commands for database schema versioning. Currently I am working with diffChangeLog command. Below is the sample format which I am working on…
Rohan
  • 29
  • 1
  • 3
0
votes
0 answers

JHipster create new Table entity without using initial schema

I recentely started using JHipster. I am facing problem while creating new tables (other than the jhipster provided). JHipster provided their tables through 00000000000000_initial_schema.xml even though same table has entity java classes. But now i…
code veda
  • 87
  • 1
  • 6
0
votes
2 answers

How to copy a database schema from database A to database B

I have created a Postgresql database A using liquibase changesets. Now, I'm creating an application that allows creating a new database B and copies the schema from database A in real-time including the liquibase changesets as the database can still…
czetsuya
  • 4,773
  • 13
  • 53
  • 99
0
votes
1 answer

For Liquibase createView, is there a way to store a value of a subsearch?

I am trying to create a view in SQL Server using a liquiBase yaml changelog file where each row looks like: employee_id | provider_id | days_remaining | employed_dates and there are three tables EMPLOYEE - employee_id, first_name, last_name …
JK Sung
  • 69
  • 1
  • 11
0
votes
0 answers

Liquibase does not work on changing Spring Boot profile

I am using Liquibase with SQL Server 2014 for my Spring Boot project. I am trying to populate a few tables at startup and update basic information in there. Everything works properly all the time, but the moment I change the Spring Boot profile,…
codeworks
  • 149
  • 1
  • 15
0
votes
0 answers

PL/SQL and SQL script in one sqlFile with liquibase for Oracle

We are trying to run a Stored procedure and a SQL statement in the same liquibase changeset using Liquibase 3.8.0 and getting below error. Unexpected error running Liquibase: ORA-06550: line 12, column 2:PLS-00103: Encountered the symbol…
user1989406
  • 11
  • 1
  • 3
0
votes
0 answers

liquibase checksum validation error is even after updating changelog in master.xml

I am using postgresql in jhipster microservices application. I am following jhipster documentation as below. Database updates with the Maven liquibase:diff goal If you have choosen to use MySQL, MariaDB or PostgreSQL in development, you can use…
Rahul
  • 493
  • 3
  • 7
  • 25
1 2 3 4 5 6
7
8