Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: import SQL script to Oracle at AIX

Re: import SQL script to Oracle at AIX

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 04 Sep 2002 10:31:32 +0200
Message-ID: <62hbnuk3hp6jv1t6486b60v4lhq8ia8ob5@4ax.com>

On 3 Sep 2002 22:09:37 -0700, gapming_at_hotmail.com (gapming) wrote:

>I have generate SQL script from MS SQL Server database.
>I want to import it into Oracle at AIX, what is the procedures?
>Also for the data in SQL Server, how can I import to Oracle database?
>
>Thank you very much.

1 None, as the SQL in Oracle is not the same as the SQL in sqlserver 2 You can use:
- Access with ODBC drivers for both Sqlserver and Oracle - the free Oracle Migration Wizard downloadable from http://technet.oracle.com
- the Oracle Heterogenous gateway.

This group is not the correct place for people who are not prepared to do at least some reading.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Sep 04 2002 - 03:31:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US