| Author |
i want to import a database from SQL Server to Oracle
|
|
| amit mota via SQLMonster.com 2005-03-30, 9:40 am |
| 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
>
| |
| Hari Prasad 2005-04-01, 7:01 am |
| 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@microso
ft.com...[color=darkred]
> Use DTS from SQL Server
>
> "amit mota via SQLMonster.com" wrote:
>
| |
| amit mota via SQLMonster.com 2005-04-05, 7:01 am |
| thanks hari
its working by SQLLDR
--
Message posted via http://www.sqlmonster.com
|
|
|
|