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

Home -> Community -> Mailing Lists -> Oracle-L -> Putting table records into sql server.

Putting table records into sql server.

From: Bowes, Chris <Chris.Bowes_at_kosa.com>
Date: Fri, 28 Jul 2000 11:56:14 -0400
Message-Id: <10572.113255@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFF8AC.5D254450
Content-Type: text/plain;

        charset="iso-8859-1"

Hi everybody,

     I have an Oracle 7 database on HP-Ux that has a few tables that another development team wants loaded into their sqlserver (v7) database. Is there any way that I could use an Oracle stored procedure to place the data from my tables into their sqlserver database? Is the best way of doing this a script on the sqlserver box that opens and reads the Oracle base and loads it up? Thank you.

--Chris
Chris.Bowes_at_Kosa.com

------_=_NextPart_001_01BFF8AC.5D254450
Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Putting table records into sql server.</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2 FACE=3D"Arial">Hi everybody, </FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp; I have an =
Oracle 7 database on HP-Ux&nbsp; that has a few tables that another = development team wants loaded into their sqlserver (v7) database.&nbsp; = Is there any way that I could use an Oracle stored procedure to place = the data from my tables into their sqlserver database?&nbsp; Is the = best way of doing this a script on the sqlserver box that opens and = reads the Oracle base and loads it up?&nbsp; Thank you.</FONT></P>

<P><FONT SIZE=3D2 FACE=3D"Arial">--Chris</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Chris.Bowes_at_Kosa.com</FONT>
</P>

</BODY>
</HTML>
Received on Fri Jul 28 2000 - 10:56:14 CDT

Original text of this message

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