Skip to Content

MSSQL Tips

Last modified by christoph_lechleitner@iteg_at on 2013-02-08 03.02:50

Installing and using MSSQL driver in Linux

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

Excluding System tables

# 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.