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.