Re: i want to import a database from SQL Server to Oracle

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:662F2701-F182-4783-8B7F-48C3EEC59280@xxxxxxxxxxxxxxxx
> 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
>>


.

Relevant Pages

  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)
  • Re: DTS error involving large tables
    ... Ok So I see a lot of people having problems with Oracle and SQL Server. ... "StephenP" wrote in message ... >>> using DTS wizard to design a very simple data export. ...
    (microsoft.public.sqlserver.dts)
  • RE: DTS Sucess but fails to go to next step when scheduled
    ... odbc connection to an Oracle database in my dts packages. ... My particular situation involves pulling data from an Oracle 9database into ... SQL Server 2000 -- when the Oracle database was in 8i it worked much faster ...
    (microsoft.public.sqlserver.dts)
  • Re: Executing DTS that connect to Oracle from an ASP page
    ... Oracle client needs to be on the caller/invoker yes. ... DTS is a client side app. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
Loading