Sursa: bd Oracle 10g

SQL> connect
Enter user-name: SYSTEM
Enter password:
Connected.
SQL> CREATE TABLE export
  2  (
  3  id int primary key,
  4  denumire varchar(25) not null,
  5  continut clob
  6  );

Table created.

SQL> INSERT INTO export (id, denumire, continut)
  2  VALUES (1,'Neamul Soimarestilor','continut carte 1');

1 row created.

SQL> commit;

Destinatie: bd SQL Server 2000 

Pe sistemul destinatie, care are SQL Server am instalat:

Oracle10g Provider for OLE DB Version 10.1.0.4.0 (including ODAC) .

Am creat o sursa de date ODBC folosind driver-ul furnizat de Oracle: Oracle in OraClient10g_home1 (pe sistemul destinatie). 

Folosind DTS / Import Export Data sau un local package definit cu Enterprise Manager am transferat datele din bd Oracle in bd SQL Server.