Child pages
  • Migrating from fancymail-server-0.1.x to fancymail-server-0.2.x on MSSQL
Skip to end of metadata
Go to start of metadata

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
  • No labels