Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
| Search | Today's Posts | Mark Forums Read
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 3rd, 2009, 04:36 AM
Authorized User
 
Join Date: Jan 2009
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Oracle to SQLServer OR SQLServer to Oracle

Hi Everybody
How are you? I think you are all well. But i have some problem. I have two pc. One pc uses SQLServer database and another uses oracle database software. I need some data from the SQLServer to Oracle. How can i transfer data from SQLServer to Oracle or ViceVersa? Is there any software to do this? Is there any trail version that can i used to evaluate my problem? Can anyone help me to give me some information or suggetion? Thanks all.

Regards
Shimul Mahmud
 
Old December 3rd, 2009, 05:16 AM
joefawcett's Avatar
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

You should be able to set up the Oracle instance as a linked server on the SQL Server machine, providing you have the Oracle connectivity tools installed. Alternatively take a look at the OPENQUERY function in SQL Server whereby the connection details are passed as part of the query.

Alternatively you can use Oracle to connect to SQL Server: http://www.databasejournal.com/featu...SQL-Server.htm although it's more hassle in my opinion.
__________________
Joe
http://joe.fawcett.name/




Similar Threads
Thread Thread Starter Forum Replies Last Post
[Microsoft] [ODBC driver for oracle] [oracle] ORA-06413: connection not open dpkbahuguna Beginning VB 6 7 May 5th, 2009 12:31 AM
Oracle SOA, BPEL and Oracle worklist umeshtheone Pro Java 1 April 16th, 2008 11:01 PM
call oracle function using oracle link server vl SQL Server 2000 1 July 12th, 2007 08:19 AM
SQLserver 2000 vs SQLserver 2005 Express cJeffreywang BOOK: Beginning ASP.NET 2.0 and Databases 0 April 22nd, 2007 09:52 AM
How to Read Oracle Data without Oracle being insta badrinarayanang Oracle 1 October 6th, 2005 06:34 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.