Child pages
  • MSSQL Tips

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

Installing and using MSSQL driver in Linux

No Format
apt-get install apache-karaf-mssql
 
jdbc2xml ... --jdbc-drivers /usr/share/apache-karaf/lib/sqljdbc4.jar

Excluding System tables

No Format
# MSSQL likes to create system tables which should not be exported or imported
jdbc2xml ... --exclude-tables sysdiagrams,trace_xe_event_map,trace_xe_action_map

We plan to respect (exclude) those table automatically in a future version, see JDBCTOXML-13.