Stack Overflow
Stack Overflow

Questions tagged [liquibase-pro]

12 questions
1
vote
0 answers

How to use sql procedure or while/for loop in liquibase 4.0.0?

I want to use for/while loop in sql file. So defined the proc sql. btw there is an error. …
guofu
  • 11
  • 3
1
vote
0 answers

Connecting Liquibase with SQL Anywhere 17

I already downloaded liquibase-4.0.0-beta1 and I'm looking to set it up with an existing SQL Anywhere 17 database. I've tried running the following command: liquibase --driver=com.sybase.jdbc4.jdbc.SybDriver --classpath=jconn4-4.0.0.jar…
Leandro
  • 11
  • 1
1
vote
0 answers

Liquibase diffChangelog does not generate rollback

If I haven't misunderstood anything, the liquibase command diffChangelog should be able to generate rollback change sets for some types of change sets like create table, rename column or add column but it is not working for me using the liquibase…
Fran García
  • 2,011
  • 16
  • 24
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: 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 - Cannot read object body

I have been attempting to track Stored Procedure changes in a MySQL DB using our Liquibase Pro trial. Not sure what else to try at this point, any and all ideas are appreciated! The Problem The command liquibase generate-changelog…
Caleb Wardlaw
  • 1
0
votes
0 answers

How to use liquibase rollback for drop statements

I am using liquibase version-4.11 connected with snowflake and i have two pipelines for database automation using liquibase one is for DB Deploy and another one is DB Rollback. We are using this pipeline for the schema updation in snowflake. The DB…
Umar Mukthar Nasoordeen
  • 1
  • 1
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
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
1 answer

LiquibasePro don't generate package, packagebody and other things in the changeLog file

I use LiquibasePro and liquibase pro don't generate package, packagebody, fuction and etc. into changeLog file. How to fix this?
Timur
  • 23
  • 1
  • 5
-1
votes
1 answer

since i don't have access tp PGsql server but I have access of PGadmin so is there any way i can connect PGADMIN to Liquibase

since I do not have access of the PGSQL server because of sensitive data but I have access of the "PGadmin" is there any way I can connect "Liquibase" to PGadmin and any change in change-log file triggers "Liquibase Update" and then PGadmin triggers…
Shivang
  • 1
-1
votes
1 answer

Need steps to implement liquibase in spring boot with docker and how to execute using docker

Need steps to implement liquibase in spring boot application with dockerfile. And Need steps for how to execute liquibase using docker.
Sathya sarma
  • 1
  • 3