
	Home > Oracle All-in-One Guides > SQL Server for the Oracle pro > Integrating Oracle and SQL Server

All-in-One Guides:

SQL Server for the Oracle pro

EMAIL THIS

START

DATA AND APPLICATION INTEGRATION BASICS

INTEGRATING ORACLE AND SQL SERVER

ORACLE VS. SQL SERVER

Integrating Oracle and SQL Server

This section of the guide compiles expert advice to help you integrate data between your Oracle DBMS and Microsoft SQL Server systems. You'll learn how to transfer data from an Oracle database to SQL Server and vice versa, plus tips on dealing with data types, stored procedures and more.



BROWSE SUBCATEGORIES:	Migrating Oracle data to SQL Server (6), Migrating SQL Server data to Oracle (6), More Oracle-SQL Server integration tips (18)


Migrating Oracle data to SQL Server: 1 - 3 of 6

Extracting data from Oracle and loading into SQL Server
What are the available options of extracting data from the Oracle 8.1.7 tables and loading it into a SQL Server 2000 database server? The data needs to be extracted as a batch process or once a day and involves more than...

How to dump SQL Server database with Oracle data
We need to dump a SQL Server 2005 database with the data from an OLTP Oracle 7.2.3 database. Should we pull data from SQL Server or push data from the Oracle DB?

How to replicate an Oracle database to SQL Server?
I am trying to find the best solution for having a database replicated from Oracle to SQL Server without creating an Oracle instance in our machine. This is not a migration; the Oracle database will continue to be used...

	VIEW ALL IN THIS CATEGORY


Migrating SQL Server data to Oracle: 1 - 3 of 6

Calling stored procedures in SQL Server to insert data in Oracle
I have two DB servers: one is SQL Server, the other is Oracle. I need to call some stored procedure in SQL Server in order to insert some data in Oracle. How I could do that?

Converting SQL Server data to Oracle
I have SQL Server and Oracle 9i on my system. I need some code or program so that I can convert my SQL Server data into Oracle data. Tools are available but I want to learn programatically to convert data between...

Exporting from SQL Server to Oracle
Can we export all procedures and triggers from Microsoft SQL Server to Oracle8i?

	VIEW ALL IN THIS CATEGORY


More Oracle-SQL Server integration tips: 1 - 3 of 18

Lessons learned: Integrating Oracle and SQL Server
Whether you're trying to execute an Oracle stored procedure on SQL Server or move data from one DBMS to another, you'll find troubleshooting advice in this collection of short lessons by Kevin Kline, our resident SQL...

Accessing SQL Server through transparent gateway
Can we access SQL Server from the Oracle server database installed on Linux through a transparent gateway installed on a Windows machine? If so how do we do that?

Configuring a link between Oracle 8i and SQL Server 2000
How can I configure a link between Oracle 8i and MS SQL Server 2000? I need to execute stored procedures in SQL Server from Oracle.

	VIEW ALL IN THIS CATEGORY

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy