Best practice to version a database

Question

I am doing an ongoing MySQL database development. I have a create database script and a set of scripts to patch it along the time. In those patch I need to check if the target database is the correct version. I am thinking to add a table to my schema for this purpose but it might overkill this problem.

I am wondering what is the best practice to do it.

THanks,

Related: http://stackoverflow.com/questions/225772/compare-two-mysql-databases — OMG Ponies, Mar 27 '12 at 01:17
@Feng, was that answer helpful? If so, please accept it; or, let me know your additional concern. — D Mac, Mar 30 '12 at 21:23
Check https://github.com/m-szalik/dbpatch-maven-plugin it does exactly what you need. — m-szalik, Jul 28 '14 at 00:01

score 0 · Answer 1 · answered Jul 27 '14 at 23:59

0

I am using maven plugin for that. It can track your database changes as well as apply missing SQL scripts.

https://github.com/m-szalik/dbpatch-maven-plugin

answered Jul 27 '14 at 23:59

m-szalik

3,398
1
19
28

score 0 · Answer 2 · answered Mar 27 '12 at 01:20

That is what I do for a number of databases - a table called schema_history, that my scripts which update the schema always add a row to: with date, version ID, purpose, etc. I can see what version any database is by looking at the last record in schema_history -- very handy.

I recommend this approach.

Best practice to version a database

2 Answers2