Upload a JDBC driver
Upload a JBDC driver (extract .jar file from the downloaded .zip file) for MS SQL Server (see http://jtds.sourceforge.net/ ) using the Webmin interface.
Export has been tested with version 1.3.1 of the jTDS JDBC driver.
Use the special Hibernate dialect included, called
This is important because internally Unicode is used as the character set. To make MS SQL Server also use Unicode, the text columns in the database must be defined with nvarchar as datatype. The default Hibernate MS SQL Server dialect uses varchar for text columns, while the SQLServerUnicodeDialect uses nvarchar.
Restart the server
In a cluster setup restart each node, one node at the time, and wait for the node to be up and running before restarting the next one.
After restarting all servers, the MS SQL Server driver will appear in the webmin interface when creating an export database.
Create a database in MS SQL
Create a database in MS SQL with a case sensitive collation. Collations in MS SQL Server includes ‘cs’ in their name if they are case sensitive; and ‘ci’ if case insensitive.
This is important because IT Advisor internally keys are allowed that only differ in upper case/lower case, for example, ‘MyProp’ is different from ‘myprop’. Such keys would result in primary key duplication errors if the MS SQL Server database is not using a case sensitive collation.
Set up the ETL export database
Set up the ETL export database in Webmin.
Make sure you have not defined any tags or custom properties that only differs in a trailing space, for example, “my key” and “my key “. Note the trailing space in the last key.
This is important, because internally such keys are seen as being different. MS SQL Server sees them as being equal, which will result in a duplicate key error. For more information on how MS SQL Server compares strings with trailing spaces see http://support2.microsoft.com/kb/316626 .
If you have two tags or two custom properties with the same name except for trailing spaces, you can merge them from the client. See for more information. Since trailing spaces are invisible in the user interface, you might want to start the merge by renaming the key you want to get rid of. For example, rename “my key “to “my key_”.