search

abdelrahman-sinno / maven-db-plugin

Automatically exported from code.google.com/p/maven-db-plugin
0 stars 0 forks source link

Does the plugin maintain the changelog #8

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
I am planning to use this plugin and so had a very basic question about its 
usage - may be just a qucik FAQ to add.

Lets say, we have a existing database with pre-loaded data

1. Should we place Database dump @ - schema scripts i.e src/main/sql/schema

2. Everytime we run db-create it will override the database?

3. Let's suppose we need to add one more column in some x table, where should 
we keep that update x.sql script? I guess in update scripts i.e in 
src/main/sql/update ?

4. If yes, does everytime we run mvn db:update, it will execute all the scripts 
there? 

5. This will cause DB errors, like adding same column again and again?

6. Let's suppose we need to add more seed-data in some x table, where should we 
keep that x-data.sql? I guess in data scripts i.e in src/main/sql/data?

7. If yes, will same problem as 4 & 5 will occur again?

In nutshell, does the plugin maintain the changelog or handle what is updated 
and what is not? So that next time goal runs nothing fails?

I would love to use this plugin and try if I get above usage explained.

Original issue reported on code.google.com by gripic...@gmail.com on 23 Apr 2015 at 6:16