Reputation: 1623
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
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
Reputation: 1549
The simplest way is flat file out of oracle, and then flat file into SQL Server.
Upvotes: 1