Migrating from fancymail-server-0.1.x to fancymail-server-0.2.x on MSSQL
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