i want to import a database from SQL Server to Oracle

hi
i am amit from india
i am new to this field
can you help to import a database from SQL Server to Oracle9i
Message posted via http://www.sqlmonster.com
Use DTS from SQL Server
"amit mota via SQLMonster.com" wrote:

> hi
> i am amit from india
> i am new to this field
> can you help to import a database from SQL Server to Oracle9i
> --
> Message posted via http://www.sqlmonster.com
>
|||Hi,
There are many options
1. DTS
2. BCP OUT the data in sql server and use SQLLDR to load the data into
Oracle.
Thanks
Hari
SQL Server MVP
"Venu" <Venu@.discussions.microsoft.com> wrote in message
news:662F2701-F182-4783-8B7F-48C3EEC59280@.microsoft.com...[vbcol=seagreen]
> Use DTS from SQL Server
> "amit mota via SQLMonster.com" wrote:
|||thanks hari
its working by SQLLDR
Message posted via http://www.sqlmonster.com