| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Putting table records into sql server.
This is a multi-part message in MIME format.
------=_NextPart_000_0046_01BFFAD9.FEE793E0 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Putting table records into sql server.SQL Server comes with a Data Transformation Service (DTS) where you establish a link to the Oracle database and use the tool to load (and alternatively) transform the rows of data.
Tom Harleman
11080 Willowmere Dr.
Indianapolis, IN 46280
317-844-2884 Home
317-843-9122 Home Office
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Bowes, Chris
Sent: Friday, July 28, 2000 12:16 PM
To: Multiple recipients of list ORACLE-L
Subject: Putting table records into sql server.
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_000_0046_01BFFAD9.FEE793E0 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Putting table records into sql server.</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D310274814-31072000>SQL=20
Server comes with a Data Transformation Service (DTS) where you =
establish a link=20
to the Oracle database and use the tool to load (and alternatively) =
transform=20
the rows of data.</SPAN></FONT></DIV>
<DIV> </DIV>
<P><FONT size=3D2>Tom Harleman<BR>11080 Willowmere Dr.<BR>Indianapolis, =
IN=20
46280<BR>317-844-2884 Home<BR>317-843-9122 Home Office<BR></FONT></P>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20
[mailto:root_at_fatcity.com]<B>On Behalf Of </B>Bowes, =
Chris<BR><B>Sent:</B>=20
Friday, July 28, 2000 12:16 PM<BR><B>To:</B> Multiple recipients of =
list=20
ORACLE-L<BR><B>Subject:</B> Putting table records into sql=20
server.<BR><BR></DIV></FONT>
<P><FONT face=3DArial size=3D2>Hi everybody, </FONT></P>
<P><FONT face=3DArial size=3D2> I have an =
Oracle 7=20
database on HP-Ux that has a few tables that another development =
team=20
wants loaded into their sqlserver (v7) database. Is there any =
way that I=20
could use an Oracle stored procedure to place the data from my tables =
into=20
their sqlserver database? Is the best way of doing this a script =
on the=20
sqlserver box that opens and reads the Oracle base and loads it =
up? =20
Thank you.</FONT></P>
<P><FONT face=3DArial size=3D2>--Chris</FONT> <BR><FONT face=3DArial=20
size=3D2>Chris.Bowes_at_Kosa.com</FONT> </P></BLOCKQUOTE></BODY></HTML>
Received on Mon Jul 31 2000 - 10:27:58 CDT
 |
 |