Having set up the basic folder structure in Automated Build Databse scripts you now need to add the mysql scripts.
You create them in PROJECT_HOME/db/mysql/testdb
db/mysql/testdb/build-mysql-testdb.xml
db/mysql/testdb/createTables.sql
db/mysql/testdb/dropTables.sql
db/mysql/testdb/populateTables.sql
db/mysql/testdb/testData.sql
The build script itself is fairly self-explanatory. It replicates the targets from the master build script. It reads the mysql.properties and schema.properties files and adds the correct jar file to the classpath.
For [...]
Entries Tagged as 'database'
Automated Build – Mysql database scripts
March 30th, 2009 No Comments
Tags: automated build · mysql
Automated Build – OracleXe database scripts
March 27th, 2009 No Comments
Having set up the database folder structure in Automated Build Database scripts you now need to add the oracle xe scripts.
You create them in PROJECT_HOME/db/oraclexe/testdb
db/oraclexe/testdb/build-oraclexe-testdb.xml
db/oraclexe/testdb/createTables.sql
db/oraclexe/testdb/dropTables.sql
db/oraclexe/testdb/populateTables.sql
db/oraclexe/testdb/testData.sql
The build script itself is fairly self-explanatory. It replicates the targets from the master build script. It reads the xe.properties and schema.properties files and adds the correct jar file to the [...]
Tags: automated build · oraclexe
Automated Build – Database scripts
March 25th, 2009 No Comments
When you’re developing a project, you put all your java code into source control. You should also include database scripts in source control. These scripts can be used by developers to keep their local copies of the database up to date in the same way as they get the latest code from source control.
As part [...]
Tags: automated build · database scripts