What to use in java spring application to create automatically DB or new tables if not exist by application?

Question

I am writing a sample application in which I wrote all sql in files.

Whenever I added new functionality I am creating new sql script.

What technology should I use when my application run first check all the script if not exist create or if any new script added create that one only. I gave files name like script1.sql,script2.sql and so on.

What did you tried so far? Please edit your question!

jogo
– jogo

2015-12-23 08:37:36 +00:00
Commented Dec 23, 2015 at 8:37 — jogo
– jogo, Commented Dec 23, 2015 at 8:37

victor · Accepted Answer · 2015-12-23 08:43:45Z

1

You are using a set of sql scripts to set up your DB. Every time you have a modification you add another script - incremental script.

You can use DB maintain for managing them. It will hold information about which scripts were executed and it will know to just execute the last patch. It seems to be exactly what you are looking for:

Keeps track of what scripts were executed ( DB version )
Can ease deployment to another environment ( with a lower DB version )
Can do much more than that , but it seems this is what you need.

PS Not sure if there are other frameworks which can do the same.

answered Dec 23, 2015 at 8:43

victor

1,6961 gold badge15 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Pawan Kumar Over a year ago

Thanks. My initial requirement is only this.

Collectives™ on Stack Overflow

What to use in java spring application to create automatically DB or new tables if not exist by application?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related