RE: [EXTERNAL] Re: Connecting to SQL Server from Oracle

Thank you, Kellyn for a quick response. It is much appreciated.

Thanks,
Amir
From: Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com> Sent: Saturday, December 10, 2022 8:36 PM To: Hameed, Amir <amir.hameed_at_sleepnumber.com> Cc: oracle-l_at_freelists.org
Subject: [EXTERNAL] Re: Connecting to SQL Server from Oracle

CAUTION: External source

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://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fsql%2Ftools%2Fbcp-utility%3Fview%3Dsql-server-ver16&data=05%7C01%7Camir.hameed%40sleepnumber.com%7C699c92b5387b49e6754208dadb180bd3%7Ced8aabd514de49829fb6d6528851af5e%7C0%7C0%7C638063193592717417%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ftruzngqMhyKL%2FRYkGHgbzT23JqyQkvxjW%2BPxBjLRvI%3D&reserved=0>

https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-sql-loader.html<https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.oracle.com%2Fen%2Fdatabase%2Foracle%2Foracle-database%2F19%2Fsutil%2Foracle-sql-loader.html&data=05%7C01%7Camir.hameed%40sleepnumber.com%7C699c92b5387b49e6754208dadb180bd3%7Ced8aabd514de49829fb6d6528851af5e%7C0%7C0%7C638063193592717417%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=0eSIU08glW05CzK5HHeJc2JMQrXU2NP80uRn8%2FxJFtY%3D&reserved=0>

Hope this helps,
Kellyn

On Sat, Dec 10, 2022 at 5:27 PM Hameed, Amir <amir.hameed_at_sleepnumber.com<mailto: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<https://nam10.safelinks.protection.outlook.com/?url=http%3A%2F%2Fdbakevlar.com%2F&data=05%7C01%7Camir.hameed%40sleepnumber.com%7C699c92b5387b49e6754208dadb180bd3%7Ced8aabd514de49829fb6d6528851af5e%7C0%7C0%7C638063193592717417%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=0Cohqy4EOhYXrqv1rxemxSr8nZLUSf1zjaPUhHCWfZc%3D&reserved=0> about.me/dbakevlar<https://nam10.safelinks.protection.outlook.com/?url=http%3A%2F%2Fabout.me%2Fdbakevlar&data=05%7C01%7Camir.hameed%40sleepnumber.com%7C699c92b5387b49e6754208dadb180bd3%7Ced8aabd514de49829fb6d6528851af5e%7C0%7C0%7C638063193592717417%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ZhA4CNmYXC1rBjejTlV1jAN7W9b6SCplfh8O1Ictwzg%3D&reserved=0>

--

http://www.freelists.org/webpage/oracle-l Received on Sun Dec 11 2022 - 02:49:07 CET