I'm wondering how I go about importing data from an Oracle BLOB (holds XML) into a SQL Server 2000 field of type ntext. When I import the data normally (using Import wizard), the data is transferred across but it is in a compressed form as seen below.
Is there a way to decompress/transform this data when copying it across to SQL Server? Or, alternatively, running a procedure to convert or decompress it at the SQL Server end? Hence the desired data to be stored in the table would be my actual xml. Keeping in mind that I'm using SQL Server 2000.