Can anyone offer advice about moving the Quartz database between dbservers.
I have Quartz storing scheduled jobs on a MSSQL database. I need to switch to over to use a PostgreSQL database instead.
I am having trouble migrating the data. I believe that the problem is the job_data column in the job_details table.
This column contains binary data. Its stored as in an 'image' type datatype on mssql and 'bytea' on postgres.
Initially I was trying to export data to .csv files then reimporting into the new database. The inserts work but when initialized Quartz throws 'Unexpected EOF' exceptions so I believe I'v broken the data in the process.
I've also tried converting this column from image->varbinary then exporting and importing and converting text->bytea which is causing a 'java.io.StreamCorruptedException' exception when quartz starts.
I'm new to Quartz and not very familiar with DB Administration so am hoping there might be a simple, obvious solution that I've overlooked somewhere?
Porting one DB blob into another DB vendor is pain, and you need to know their storage structure details to do it, such is the case with yours.
I haven't done this before, but I wonder if you can use the quartz API to read all the objects (JobDetail, Trigger, Calendar etc) from one scheduler instance(with your old db) and then insert into another scheduler instance(new db). You can do this without starting the scheduler. The underlying quartz API should auto convert the Blob for you.