Also Please explain in terms of Different Evironemnts like dev,qa,stage,prod ------ Suppose some database related changes has been recently pushed to dev branch from local . QA's are still not able to see the new table changes . Whatever changes I did in my local should also be available in dev , qa , stage as code gets pushed to respective environments. So Once code gets pushed to qa env they should be able to see the changes which is being taken care by flyway.
Thank you. I would like to emphasize that there must be two underscores in the file name, otherwise there will be an error "SQL migrations were detected but not run because they did not follow the filename convention."
I don't think we need entities to be defined in order to manage/migrate the changes.... all you need to have is properties defined in application.properties and the sql script... It will auto migrate...
so is there like we can also go back to the previous version of db? like we do in git just go back to prev version of project in case you did some mistake
Thank you for the detailed explanation. Will this flyway supports plsql queries also, I mean if i have sql file as combination of sql and plsql scripts then can we do this with Flyway?
One question We can also do this with git. We can use an SQL file and commit every time changes are done. With this new joiner can know who made what changes and when? Please help me to understand
Hi, thank you for the demo it's really helpful. I have one question should isn't a migration project should be a sub-module project of main project, and run the migration using the cmd script so that the migration code doesn't run everytime. It should be execute when we want to run the migration. If so how can we do this can you please explain in details.
Thanks. You explained the concept extremely well. I have a question though. Why don't we have just one V1_SQL file and make changes to the same file whenever there is a change request. We can check-in the file in GIT thereby we can also keep track of how the tables have changed. Why maintain multiple versions(V1, V2 etc) of sql file?
if you have a multiple change, instead of adding something new to the old file and making it longer, you just add another property to new file. easy to read, easy to maintain. just like having different css, js and html files. you can just put all of em into one html file but is this the right way?
Hi, I have one question here why they given name as "Migration"?. Migration has different meaning right -migration mean from one framework to another (oracle to mysql example). Does it flyway migration or flyway version control?
You can use schema name in db connection it will use that as default schema for your database whatever schema you want to use. Flyway auto handling it's tracking in one table in same schema Am I got your question right way?
Please make vedio on how to deploy spring boot application with MySQL database containing (entities) to Google cloud platform.Is this flyway will help me to save the database of MySQL to the cloud SQL ??? Please reply n make vedio on this
NICE VIDEO ♥♥♥ Excuse the question, it is the first api I am making. Is the database created automatically? Or we can add a file to "migration" with the name "V1__CreateDb". If it can be created, what command do you use to create it?
Hi Basant Bro, This is Awesome video for Database Migration. My question is how to identify which user was modified in DB in past? How to keep on track on FlyWay?
@@ia5687 you think that cuz you probably speak the same english as him, but if you watch a channel like Java Brains you will see what understandable english sounds like.
@@ia5687 i did not say anything about the value of the tutorial, for people that understand it its probably good, but i can guarantee there are alot of people that struggle with this english, did not want to be mean but it is what it is.
Kristiyan i didn't get this kind of comment before about English. it would be easy for you to understand if you can enable subtitles also I will take this point further to improve my communication. @Idress calm down buddy everyone has their own opinion I am really happy that you like my content and support me .
Also Please explain in terms of Different Evironemnts like dev,qa,stage,prod ------ Suppose some database related changes has been recently pushed to dev branch from local . QA's are still not able to see the new table changes . Whatever changes I did in my local should also be available in dev , qa , stage as code gets pushed to respective environments. So Once code gets pushed to qa env they should be able to see the changes which is being taken care by flyway.
Thank you. I would like to emphasize that there must be two underscores in the file name, otherwise there will be an error "SQL migrations were detected but not run because they did not follow the filename convention."
Excellent Video!
Great...ofcous, we r using it in the current working project.
As always awesome. Thanks for sharing.
I don't think we need entities to be defined in order to manage/migrate the changes.... all you need to have is properties defined in application.properties and the sql script... It will auto migrate...
Thank you so much brother! It is really helpful.
this was a very good tutorial, thanks for the help
Thanks for sharing your knowledge with us!!
Great tutorial man, thank your very much!
Thanks for watching this video? Thanks for sharing this video, more like it! Thanks buddy!
so is there like we can also go back to the previous version of db? like we do in git just go back to prev version of project in case you did some mistake
Thank you for the detailed explanation. Will this flyway supports plsql queries also, I mean if i have sql file as combination of sql and plsql scripts then can we do this with Flyway?
Yes it will
Please make one video for how insert and retrieve data from snowflake database. Currently trending and entire RUclips no one done proper connection.
Noted . Will plan it
Nice video!.Helped me a lot!.
Great video
But why do we have to insert the sql command for all changes?? Repository does that automatically right?
No it won't we are doing it for audit purposes as well
One question
We can also do this with git. We can use an SQL file and commit every time changes are done. With this new joiner can know who made what changes and when? Please help me to understand
If you will use git then it requires users manual intervention isn't it. It won't help for auditing
Hi, thank you for the demo it's really helpful. I have one question should isn't a migration project should be a sub-module project of main project, and run the migration using the cmd script so that the migration code doesn't run everytime. It should be execute when we want to run the migration. If so how can we do this can you please explain in details.
In Maven multi module project You want to perform db migration using query and expecting it to run once ?
Did I understand your requirement correctly?
@@Javatechie Yes
Yup same concept I saw as part of my project I will check and update
@@Javatechie Do you have any video communicating among microservices using apache Kafka pop and subscribe
Not exactly but you can check out spring cloud stream tutorial once .
Great tutorial man but I am facing an issue that migrations are not applied .
Giving:No migrations found .Are your locations set up correctly ?
Is it possible to downgrade to lower versions? and naming convention can be changed?
Thanks. You explained the concept extremely well. I have a question though. Why don't we have just one V1_SQL file and make changes to the same file whenever there is a change request. We can check-in the file in GIT thereby we can also keep track of how the tables have changed. Why maintain multiple versions(V1, V2 etc) of sql file?
No it's good to have multiple version , it will easy for developer to find out latest changes .
Yes we can do change in single yile
@@Javatechie Thanks a lot, buddy
if you have a multiple change, instead of adding something new to the old file and making it longer, you just add another property to new file. easy to read, easy to maintain. just like having different css, js and html files. you can just put all of em into one html file but is this the right way?
Just create a file with latest version number.
Can we change the existing table name without creating a new table using this flyway migration tool ?
Excellent!
Does flyway also validate table schema against entity?
Yes it do
@@Javatechie can you elaborate it more with explanation?
Can we do it without restart of service? like when ever a file getz added automatically flyway should pickup and execute..
Hi,
I have one question here why they given name as "Migration"?. Migration has different meaning right -migration mean from one framework to another (oracle to mysql example). Does it flyway migration or flyway version control?
No it is DB migration and flyway version control the reason they named it migration I believe as indicate version migration
very good
How we can pass parameterize schemes during deployment?
Amit didn't get you
You can use schema name in db connection it will use that as default schema for your database whatever schema you want to use.
Flyway auto handling it's tracking in one table in same schema
Am I got your question right way?
I am getting this error : Caused by: java.sql.SQLException: Cannot proceed, because event scheduler is disabled
How can I redeploy same script again (for ex V1__db script.sql need to deployed again)?
tq very much finally i did
Смотреть без звука
Please make vedio on how to deploy spring boot application with MySQL database containing (entities) to Google cloud platform.Is this flyway will help me to save the database of MySQL to the cloud SQL ??? Please reply n make vedio on this
Hi, can I have to data sources? one as a source and the other as target? how can I do this, do you have demo? thank you
Didn't get your question
@@Javatechie I'm asking if it's possible to do a migration by connecting two databases. Database A is the source and Database B as the target.
No it's not possible using this
@@Javatechie okay, thank you
When i added Flyway it dint build db file in srs/main folder,. Why is it so ?
Great video! Dont we need to use flyway maven plugin? Tks
Not required if you are using spring Boot
After adding licensed key getting error like flywayException :. missing License key kindly help me
Awesome ❤️
NICE VIDEO ♥♥♥ Excuse the question, it is the first api I am making. Is the database created automatically? Or we can add a file to "migration" with the name "V1__CreateDb". If it can be created, what command do you use to create it?
As I enable hbm2.ddl.auto , jpa will create table for us but if you want you can add a SQL script under resources folder . Either way you can try
What is *baseline-on-migrate=true* for here?
How to handle table association with flyway?
Nice one , Great
I am not able to use flyway license
What is the problem? Any error ?
how to store fingerprint to database using spring boot?
How to config the flyway in yml?
Thanks
thankyou so much
perfect
Hi Basant Bro, This is Awesome video for Database Migration.
My question is how to identify which user was modified in DB in past? How to keep on track on FlyWay?
I think it should be under installedBy like in this example it is root.
Hi Mukesh good question , I will check it and update here
@@Javatechie Thank you Basant Bhai
thanks you
Thanks a lot
learn to speak english if you want your channel to have more views
@@ia5687 you think that cuz you probably speak the same english as him, but if you watch a channel like Java Brains you will see what understandable english sounds like.
@@ia5687 i did not say anything about the value of the tutorial, for people that understand it its probably good, but i can guarantee there are alot of people that struggle with this english, did not want to be mean but it is what it is.
Kristiyan i didn't get this kind of comment before about English. it would be easy for you to understand if you can enable subtitles also I will take this point further to improve my communication. @Idress calm down buddy everyone has their own opinion I am really happy that you like my content and support me .
@@Javatechie yeah sry i could have worded it nicer, its my fault he reacted so strong.
Great tutorial man but I am facing an issue that migrations are not applied .
Giving:No migrations found .Are your locations set up correctly ?