Wiki source code of MSSQL Tips
Last modified by christoph_lechleitner@iteg_at on 2013-02-08 03.02:50
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
| |
1.1 | 1 | = {{id name="MSSQLTips-InstallingandusingMSSQLdriverinLinux"/}}Installing and using MSSQL driver in Linux = |
| 2 | |||
| 3 | {{code language="none"}} | ||
| 4 | apt-get install apache-karaf-mssql | ||
| 5 | |||
| 6 | jdbc2xml ... --jdbc-drivers /usr/share/apache-karaf/lib/sqljdbc4.jar | ||
| 7 | {{/code}} | ||
| 8 | |||
| 9 | === {{id name="MSSQLTips-ExcludingSystemtables"/}}Excluding System tables === | ||
| 10 | |||
| 11 | {{code language="none"}} | ||
| 12 | # MSSQL likes to create system tables which should not be exported or imported | ||
| 13 | jdbc2xml ... --exclude-tables sysdiagrams,trace_xe_event_map,trace_xe_action_map | ||
| 14 | {{/code}} | ||
| 15 | |||
| 16 | We plan to respect (exclude) those table automatically in a future version, see [[JDBCTOXML-13>>url:https://jira.clazzes.org/browse/JDBCTOXML-13||shape="rect"]]. |