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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Importing from SQL server 6.5

Re: Importing from SQL server 6.5

From: Roger <NOrgSPAM_at_mcs-hh.de>
Date: Fri, 11 Feb 2000 22:21:15 +0100
Message-ID: <881ues$6ca$1@opal.hamburg.cityline.net>


You can buy additional Gateways to connect your Oracle server to other datasources, but since SQL Server can connect to any ODBC datasource you may be able to export your data this way.

Regards

   Roger

BTW: Since I'm using SQL server 7.0 I'm not sure if 6.5 can connect to other ODBC datasources. The connection from SQL Server 7.0 to Oracle works.

<mshabrawi_at_excite.com> schrieb in im Newsbeitrag: 87sb89$nch$1_at_nnrp1.deja.com...
> Hello All,
>
> We have an application that uses an SQL 6.5 server, we need to
> import it to work on Oracle 8i
>
> What is the best way to do this ?
>
> Is it possible to connect to the SQL server from oracle server and
> import all the table definitions, relation and data , then rebuild all
> the forms and program units using form builder or there is another
> simpler way to import the whole application ?
>
> Any help would be greatly appreciated.
> Thanks in advance,
> M. EL Shabrawi
>
>
>
>
>
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Feb 11 2000 - 15:21:15 CST

Original text of this message

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