can you please create a video and explain how to implement shared DB and separate Schema architecture using Spring boot, Postgres, hibernate, JPA repository, migration using Liquibase
I have updated dependency in pom file and added plugin as well and mentioned liquibase properties file path and created liquibase properties and mentioned everything in liquibase properties file and changelog.sql as well but it's is not working. Getting error the database url has not been specified either as a parameter or in a properties file. Can you please help here.
Ahh.. why you are getting postgres driver error while using MySQL.. maybe you can check the db url .. also you have to add MySQL driver. Instead of postgres db
Sorry, didn't get that.. you want docker download link or docker video link?? Anyways if you are looking for anything related to docker I've already created a video on docker recently, you can check that. Thanks 🙂
In my project, I need to migrate the DB From Oracle to Postgres. I’m following your tutorial. But when I’m executing below command in IntelliJ mvn liquibase:generateChangeLog - Dliquibase.outputChangeLogFile=src/main/resources/db/existing_data.sql It is taking hours to execute. When I say hours, I found it to be executing more than 1 hour 45 minutes and still it was running. Why so ? Is it processing all the tables? NOTE:- I only need a few tables to be migrated not all tables
Ideally it should not take much time. Maybe there is some issue while establishing the connection with DB. Like it was retrying again and again.. I mean, I haven't seen this issue before so not sure about the issue here.. regarding migrating only few tables, so when you generate the changelog for the existing tables, after that you can just use only those commands which you want... Means you will get the DB queries for existing tables once you run this command and then you can filter out those queries which you don't want.
@@proofofconceptcode Is there a way to populate the changelog.sql with the Create Command of those tables which ‘re intended to be migrated instead of populating it with the Create Commands of all the Tables ?
Good information,well done, keep it up Chandan
most informative video for a beginner Thank you❤. and please make some more videos on trending topics of spring
can you please create a video and explain how to implement shared DB and separate Schema architecture using Spring boot, Postgres, hibernate, JPA repository, migration using Liquibase
I have updated dependency in pom file and added plugin as well and mentioned liquibase properties file path and created liquibase properties and mentioned everything in liquibase properties file and changelog.sql as well but it's is not working. Getting error the database url has not been specified either as a parameter or in a properties file. Can you please help here.
Here I am using SQL server
Can you share your GitHub link? I'll check. Please share further details in email attached in description
Please make a separate video on Docker.
In progress🔥🔥
Hi, does this tool support database comparison between two different databases?
@user-te9tt1de3h yes... I've talked about that at the end of the video
@@proofofconceptcode it is free right?
Can we run this command for mysql database mvn liquibase:update it is giving error "Cannot find database driver: org.postgresql.Driver".
Yes.. maybe you are missing adding driver in properties file
@@proofofconceptcode thanks for the reply , I have added .xml file and didn't remove postresql connection with mysql connection.
Ahh.. why you are getting postgres driver error while using MySQL.. maybe you can check the db url .. also you have to add MySQL driver. Instead of postgres db
Great infomation.
Could you please make video on spring boot gradle project with sonarqube on IntelliJ idea
Thanks! 🙏 Sure, will make a video on that but gradle is new for me.. I mostly worked on maven. So I'll try to make a video on that
Please share docker link to ready docker
Sorry, didn't get that.. you want docker download link or docker video link?? Anyways if you are looking for anything related to docker I've already created a video on docker recently, you can check that. Thanks 🙂
In my project, I need to migrate the DB From Oracle to Postgres. I’m following your tutorial. But when I’m executing below command in IntelliJ
mvn liquibase:generateChangeLog - Dliquibase.outputChangeLogFile=src/main/resources/db/existing_data.sql
It is taking hours to execute. When I say hours, I found it to be executing more than 1 hour 45 minutes and still it was running. Why so ? Is it processing all the tables?
NOTE:- I only need a few tables to be migrated not all tables
Ideally it should not take much time. Maybe there is some issue while establishing the connection with DB. Like it was retrying again and again.. I mean, I haven't seen this issue before so not sure about the issue here.. regarding migrating only few tables, so when you generate the changelog for the existing tables, after that you can just use only those commands which you want... Means you will get the DB queries for existing tables once you run this command and then you can filter out those queries which you don't want.
@@proofofconceptcode
Is there a way to populate the changelog.sql with the Create Command of those tables which ‘re intended to be migrated instead of populating it with the Create Commands of all the Tables ?
No, but if you see any data inside those tables then it seems that those commands has done something