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."
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 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?
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
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.
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
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?
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?
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
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?
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 .
Great...ofcous, we r using it in the current working project.
Excellent Video!
Thanks for watching this video? Thanks for sharing this video, more like it! Thanks buddy!
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."
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.
As always awesome. Thanks for sharing.
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
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...
Thanks for sharing your knowledge with us!!
Great tutorial man, thank your very much!
Great tutorial man but I am facing an issue that migrations are not applied .
Giving:No migrations found .Are your locations set up correctly ?
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 so much brother! It is really helpful.
this was a very good tutorial, thanks for the help
Can we change the existing table name without creating a new table using this flyway migration tool ?
Please make one video for how insert and retrieve data from snowflake database. Currently trending and entire UA-cam no one done proper connection.
Noted . Will plan it
Does flyway also validate table schema against entity?
Yes it do
@@Javatechie can you elaborate it more with explanation?
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 .
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
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.
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
Is it possible to downgrade to lower versions? and naming convention can be changed?
Can we do it without restart of service? like when ever a file getz added automatically flyway should pickup and execute..
Excellent!
Awesome ❤️
Nice video!.Helped me a lot!.
tq very much finally i did
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
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
Great video! Dont we need to use flyway maven plugin? Tks
Not required if you are using spring Boot
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
What is *baseline-on-migrate=true* for here?
How can I redeploy same script again (for ex V1__db script.sql need to deployed again)?
Thanks
Смотреть без звука
thanks you
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
thankyou so much
perfect
Nice one , Great
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 a lot
When i added Flyway it dint build db file in srs/main folder,. Why is it so ?
How to config the flyway in yml?
After adding licensed key getting error like flywayException :. missing License key kindly help me
How to handle table association with flyway?
I am not able to use flyway license
What is the problem? Any error ?
how to store fingerprint to database using spring boot?
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 ?