473,233 Members | 1,471 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,233 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 1707
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Philip D Heady | last post by:
Ok I'm a newbie to using Oracle9i w/ PHP, been a MySQL guy... What is the proper sql statement to use insert tables, etc. as below.? I don't know much about how OciParse works. I can connect...
3
by: TK | last post by:
I have a problem getting ADOdb working with Oracle 9i. Before I tried to connect to Oracle, I successfully connected to an MS Access table via a DSN, and looped through all the records in that...
4
by: Mike D | last post by:
I want to connect to an oracle database from my client pc, OS is win2k or XP. Can I connect to an oracle database without having the full oracle client installed? If so what would be the minimum...
5
by: madunix | last post by:
i want to implememt private area(authorized users)in the internet main page. Our Backend Database Server running Oracle 9i on AIX I am looking for a solution to pull up live data form Backend...
63
by: Nick Palmer | last post by:
Hi all, Is there a DB2 equivilant to Oracle's DB Link functionality ? I have two DB2 databases and I need to get access to the tables in one from the other. In Oracle I would just create a DB...
11
by: Rosco | last post by:
Does anyone have a good URL or info whre Oracle and Access are compared to one another in performance, security, cost etc. Before you jump on me I know Oracle is a Cadillac compared to Access the...
3
by: Geoff Muldoon | last post by:
Hi all, Oracle 10g RAC on Linux, with an end-user interface via Apache/PHP/AdoDB on a separate Linux box. I need to create a PHP web interface to allow an end-user to run a PL/SQL stored proc...
5
by: dreadnought8 | last post by:
I've worked with mdbs, and with SQL Server to a lesser extent, with Access as a front end, on commercial-strength systems for quite a while, starting with A97. The last 8 months or so, I've been...
2
by: Vinod Sadanandan | last post by:
All, Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features . Precompilers:...
23
by: Gloops | last post by:
Hello everybody, Is anyone able to give me some indications about how to develop an Access interface for an Oracle database ? I dispose of Access 2003 (11.6566.8107) SP2, Oracle 9i 9.2.0.1.0...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.