AMQ 4 to 5: Database schema upgrade

[Michal <ca...@yahoo.com>]

I am using activemq 4.0 with jdbc persistance. Now I want to migrate to
version 5.0.
My database contains messages. I would like to have the same messages in 
AMQ after upgrade. As a last resort I could start both brokers (4 and 5) and
copy messages (consume from 4 and produce to 5) - but that would be really
painful process and I could loose some important metadata.

I could not find any db migration script in AMQ release, also AMQ website
does not mention this either.

I see that there were some small changes in the schema (f.e. sub_dest column
in table ACTIVEMQ_ACKS)

The questions are:
* can I get somewhere db migration scripts?
* if I identify changes manually, would it be safe to assume that only
schema has changed - content is still the same (so broker 5 will safely host
messages from 4)?
* What are other good techniques (tips) to copy messages (ideally without
loosing its metadata) from version 4 to version 5.


Thanks
Michal


-- 
View this message in context: http://www.nabble.com/AMQ-4-to-5%3A-Database-schema-upgrade-tp17313145s2354p17313145.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.