The only satisfactory solution, I have found, is to create the objects first
on Oracle with the correct types etc, then use DTS to transfer the data
only.


Alistair Connor
Ext/Astek
DBA Sql Server
tél 598131


-----Message d'origine-----
De : RAVICHANDRAN KRISHNASWAMY [mailto:[Email Address Removed]
Envoyé : jeudi 26 décembre 2002 09:41
À : LazyDBA.com Discussion
Objet : ORACLE DATABASE IMPORT INTO MS SQL SERVER 2000

Question :
while importing data from oracle to SQL-Server 2000
using DTS in SQL Server i have done
1.checked the include Primary key in option in Column Mapping
tab page.
2.In Constraint tab page i have checked include Primary key
option

The table has been succesfully imported.I have got

1.The varchar2 data type imported as Char
2.The Primary key constraint is not transfered

Is there any solutions?


S.Sivakumar
System Analyst
Indus Cybertech Pvt. LTd.
Chennai.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page