Mike
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
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
Mike McAllister

Reputation: 1549

The simplest way is flat file out of oracle, and then flat file into SQL Server.

Upvotes: 1

Related Questions