Re: Connecting to SQL Server from Oracle
Date: Sat, 10 Dec 2022 17:35:42 -0800
Message-ID: <CAN6wuX1iAL09jqdjUtLhUU7BeM-WD1prcpVarort6YhybXtXVQ_at_mail.gmail.com>
I’ve done this tons of times in the 25 years as an Oracle/SQL Server DBA and if you just need to do a monthly dump of data from SQL Server and load to Oracle, it’s likely you can bypass the Gateway-
You’re looking to do a simple BCP, (Bulk Copy Protocol) script from SQL Server to a CSV format and then use SQL Loader to just dump it into Oracle.
https://learn.microsoft.com/en-us/sql/tools/bcp-utility?view=sql-server-ver16
https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-sql-loader.html
Hope this helps,
Kellyn
On Sat, Dec 10, 2022 at 5:27 PM Hameed, Amir <amir.hameed_at_sleepnumber.com> wrote:
> Hi,
>
> Is there a way to establish a connection from Oracle to SQL Server without
> using the Oracle Gateway? We have a requirement to pull data from SQL
> Server and into Oracle only once a month and we don’t want to spend money
> on licensing Oracle Gateway. The OS platform is for Oracle Solaris.
>
>
>
> Thank you,
>
> Amir
>
>
>
-- *Kellyn Gorman* DBAKevlar Blog <http://dbakevlar.com> about.me/dbakevlar -- http://www.freelists.org/webpage/oracle-lReceived on Sun Dec 11 2022 - 02:35:42 CET