Mike
Reputation: 1623
How to push data from an Oracle table to a SQL Server table?
How best to periodically push data from a table in Oracle 10.2.0.4 to a table in SQL Server 2008 SP2? The two tables are exactly alike, other than the necessary differences in datatypes.
I'm hoping to find a way that does not involve purchasing 3rd party software.
It needs to be automated and periodic. The SQL Server is Standard edition.
Upvotes: 0
Views: 762
Answers (2)
jrara
Reputation: 17021
I would suggest that you create an SSIS task for this purpose. Then you can use SQL Agent to schedule this task.
Upvotes: 0
Mike McAllister
Reputation: 1549
The simplest way is flat file out of oracle, and then flat file into SQL Server.
Upvotes: 1
Related Questions
- integrate data between oracle and sql server
- Oracle DB Table to SQL Server DB Table
- Getting Data from an Oracle database to SQL Server
- How do you pull data from SQL Server to Oracle?
- Copying from Oracle into a SQL Server table
- How to automatically push data from SQL Server to Oracle?
- Move Data from Oracle to SQL Server
- use c# to copy table data from oracle to SQL Server?
- Insert rows into a SQL Server table from Oracle
- How can I transfer data from a SQL table to an Oracle table?