471,049 Members | 1,401 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

Oracle/MS SQL Interface

Hi everyone. I need to be able to query a database in Oracle and then
actually save the data in an MS SQL database, does anyone know what is
the best way to do this? Would it be best to do everything internal
(inside MS SQL) or external (with some script: javascript, vbscript,
perl)?

Thanks in advanced,
Mike

Dec 27 '05 #1
6 1649
Sorry for the repeat, I didn't think my last one went through.

Dec 27 '05 #2

brogdonm wrote:
Hi everyone. I need to be able to query a database in Oracle and then
actually save the data in an MS SQL database, does anyone know what is
the best way to do this? Would it be best to do everything internal
(inside MS SQL) or external (with some script: javascript, vbscript,
perl)?

Thanks in advanced,
Mike


It depends on what additionally you want to do with the data. If you
are looking to simply replicate your Oracle data in MS SQL Server use
DTS. If you are looking to present the data, say in a web page, you
might want to use any of the various scripting languages.
You'll still end up doing quite a bit internally, probably with views
and stored procedures.
That's my guess.

Thanks

Dec 28 '05 #3
Hi

You may want to look at using a linked server, see Books online for more
information.

John

"brogdonm" <Br******@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
Hi everyone. I need to be able to query a database in Oracle and then
actually save the data in an MS SQL database, does anyone know what is
the best way to do this? Would it be best to do everything internal
(inside MS SQL) or external (with some script: javascript, vbscript,
perl)?

Thanks in advanced,
Mike

Dec 28 '05 #4
I don't really know what DTS is, could you please inform me.

Dec 28 '05 #5
brogdonm (Br******@gmail.com) writes:
I don't really know what DTS is, could you please inform me.


DTS = Data Transformation Services. This comes with SQL Server. DTS is
a tool for exporting and importing data. If you would like to drag
you entire table over to Oracle, this could be a good choice, particularly
if you are doing it on regular basis. Disclaimer: I have never used DTS
myself.

But if you want to run ad-hoc queries aginst the Oracle table, then it's
better to set up a linked server. You can then access the Oracle table
with four-part notation:

SELECT * FROM ORACLE.catalog.schema.tbl

and also join with local tables.

For information on setting up a linked server, see sp_addlinkedserver
in Books Online.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 28 '05 #6
Hi

You may walso want to check out http://support.microsoft.com/kb/280106/

John

"brogdonm" <Br******@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
I don't really know what DTS is, could you please inform me.

Dec 29 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Philip D Heady | last post: by
3 posts views Thread by TK | last post: by
4 posts views Thread by Mike D | last post: by
5 posts views Thread by madunix | last post: by
63 posts views Thread by Nick Palmer | last post: by
11 posts views Thread by Rosco | last post: by
3 posts views Thread by Geoff Muldoon | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.