Without sql command:
1- with data-management: export the db
java -Xmx512m -jar data-management-cli-1.1-beta-2-app.jar -buildsJdbcUrl
jdbc:derby:path_continuum_old_db -mode EXPORT
2- start Continuum to create an empty db (with the good schema)
3- stop Continuum
4- import datas with data-manage
And this is what I did...
I pulled the database someplace that I could run squirrelsql and ran the
following sql statements to update the database, then I put the database
back into place and started the updated version.
--
ALTER TABLE INSTALLATION ADD installation_id integer not null defaul
Here's what I did (this is a once off thing, though we really need to
make sure changes are backwards compatible and can handle missing
metadata in the future...)
- run data-management from 1.1-beta-1 to export the build database (I
had to build this from source)
- edit the exported builds.