Description:
Now there are two systems. One major system uses Oracle, which is called oracleproject. Another system uses SQL Server, which is called sqlserverproject. Now you need to synchronize their data. The primary database is Oracle, and SQL server needs to be updated. The two databases have different data table structures.
How can this problem be solved?
I have never done it before and will gradually write out the solution. Do not give me any suggestions. :) Thank you.
The following method is used: sqlserver database --> Security --> linked servers. Add the Oracle database here. For example, the name of the linked server is LS, the schema of Oracle is lsschema, and the data table is table1. Then, you can use the following statement to query the Oracle data table in sqlserver.
Select * from LS .. lsschema. Table1
Note that ls is followed by two decimal points.