All geek questions in one place

How to transfer data from a SQL Server database to an Oracle database

The current application I'm working with allows you to call X, an application for archiving data stored in another application. Y. Both are very old applications developed about 8-odd years ago. Until now, in my reading of the documentation, I found out that the data transfer process is used in that the snapshot of the SQL Server database is created in flat files, and then these flat ftp'd files correspond to the correct unix block, where through ctl for the Oracle database various insert instructions are created and how this data is transmitted. It uses the bcp utility. I wanted to know if there is a better and faster way to do this. There should be a way to transfer data directly, I feel that the whole process of receiving it into files, and then the transfer and insertion should be very slow and painstaking. Any ideas ???

+3
source share
2 answers

Create a database link from the Oracle Database to SQL Server, and you can transfer data using selects / inserts.

Schedule the process using DBMS_SCHEDULER if you need to do this on a periodic basis.

+2
source

You can read data from many different database providers using heterogeneous services. To use this, you create a service in a Unix window that uses - in this case - odbc to connect to the SQL Server database.

listener.ora, tns, . , (hs = ok). , tns .

UnixODBC FreeTDS . , 10g - hs4odbc, 11g dg4odbc.

+1

Source: https://habr.com/ru/post/1794352/

More articles:


All Articles