Migrating from fancymail-server-0.1.x to fancymail-server-0.2.x on MSSQL

Owned by Wolfgang Glas
Last updated: 2012-10-15Version comment
1 min read

fancymail-0.2.0 introduced an HiLo-IdGenerator in favor of tuo-increment columns.

However, the automatic schema update is unbale to remove auto increment functionality from MSSQL tables.

Hence, you have to dump and recreate your FANCYMAIL database after upgrading to fancymail-server-0.2.0 using the se commands:

"C:\Program Files\jdbc2xml\bin\jdbc2xml.exe" --from-url "jdbc:sqlserver://127.0.0.1:1433;databaseName=FANCYMAIL" --from-user fancymail --from-passwd "liamycnaf!" --to-file FANCYMAIL.xml.bz2 --no-auto-increment-check --exclude-tables trace_xe_event_map,trace_xe_action_map

Reimporting the database is established using:

"C:\Program Files\jdbc2xml\bin\xml2jdbc.exe" --to-url "jdbc:sqlserver://127.0.0.1:1433;databaseName=FANCYMAIL" --to-user fancymail --to-passwd "liamycnaf!" --from-file FANCYMAIL.xml.bz2 --drop-tables --exclude-tables trace_xe_event_map,trace_xe_action_map